Forum Discussion

prudhvi_kumar's avatar
prudhvi_kumar
New Member
4 years ago

Logical DAX Expressions

table A A B C D True false True false   More than 100 columns i have like this, where True , False are there i need "yes" or "no" over there.Without create new columns is it possibl...
v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi prudhvi_kumar ,

 

It seems no way to create a "Logical DAX" and only one by one. However, use unpivot other columns in power query to let these columns into one column, then use DAX to get the result.

 

By the way, can you share what you will do after get the result. There may be ways to bypass the need to create similar measures to get the results you want directly.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.