How to pass NULL values in IF statement in DAX

[Sreya]

It is Solved Now by putting "" or BLANK() in IF statement

[v-xuding-msft]

Hi @Sreya ,

Glad that you have resolved it. Can you please reply your thread again and accept it as solution? Then this thread will be closed. Others who have the same questions will find the solution quickly and benefit from it. Thanks in advance!

[FarhanAhmed · Accepted solution]

Why exactly you want NULL values in return from DAX Query?

If you want to compare NULL values of/from Datasource then the BLANK() function should suffice your needs.

Ref: https://docs.microsoft.com/en-us/dax/blank-function-dax

In the original data source, the column evaluated by the BLANK function might have included text, empty strings, or nulls. If the original data source was a SQL Server database, nulls and empty strings are different kinds of data. However, for this operation, an implicit typecast is performed and DAX treats them as the same.