Oh Thanks For Ur Reply..I Use list()..Hence it Works..
Select returns a list.
" " is a text.
The types have to match.
Right. @BHUVANESH, for the "else" argument you can return an empty list: LIST().
Your SELECT function returns all records. So, you could probably omit it and use just Invoice[Customer].
Potentially, it would also work to instead use just IFS(): IFS([Type] = "Billing", Invoice[Customer]).
Oh Thanks For Ur Reply..I Use list()..Hence it Works..
User | Count |
---|---|
41 | |
28 | |
25 | |
17 | |
13 |