How to Check if column is availalbe in DAX

[Anonymous]

Hi Team,

We have a scenario where column may avaialble or may not avaialble from backend ( MongoDB ).  We wanted to handle a exception where if a column is not avaialble it should  get replaced by by custom column/ Calculated column in DAX (null values ). Is there any way to handle this in M-Quey or DAX ? 

Thanks,

Shubham

[parry2k · Accepted solution]

@Anonymous you can handle this in power query not in DAX, check this post

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[Anonymous · Accepted solution]

HI @Anonymous,

Perhaps you can use the #table function to define the default table structure, then you can load current data into a defined table. (these not existed fields will display with null value)

Creating Tables In Power BI/Power Query M Code Using #table() 

Ensuring Columns Are Always Present In A Table Returned By Power Query 

Regards,

Xiaoxin Sheng

[kentyler]

In M and DAX you can create a calculated column that says

if such a column is null, it lies the value of this other column, otherwise the value of the first column
IF(ISBLANK(column1), IF(ISBLANK(column2, column3),column4)

[parry2k · Accepted solution]

@Anonymous you can handle this in power query not in DAX, check this post

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

[richardcalvert]

The question was how to handle this in DAX.
The appropriate answer seems to be that there is no function in DAX for testing if a column exists in a table.

You could create a table in dax that had all the columns you wanted (and null or empty values) and append (UNION) it together with your data table, but this is unlikely to be better than an MQuery option.