How to make This expression Crct?

[BHUVANESH]

If type= Non Billing ..I need Customer Column Blank text...

[TeeSee1]

Select returns a list.

" " is a text.

The types have to match.

[dbaum]

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]).

[BHUVANESH · Accepted solution]

Oh Thanks For Ur Reply..I  Use list()..Hence it Works..