Logical DAX Expressions

[prudhvi_kumar]

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 possible to create any measure for the same.

[Aburar_123]

Hi @prudhvi_kumar ,

Please use the Power Query Transformation as below,

Select Row No column then Go to Transform widow -> Unpivot Column -> Unpivot Other Columns

it will give you the result as below,

Then, Go to Add Column -> Custom Column options and write the below,

and get the result as below,

In the visual pane you can create the Matrix visual as below,

If this post helps, then please Accept this as the solution. Thanks

[v-chenwuz-msft]

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.

[mwegener]

Hi @prudhvi_kumar ,

can you customize the data type and custom format?

[johnt75]

Can you use power query instead of DAX? You could transform the data during load changing TRUE to Yes and FALSE to No.

[prudhvi_kumar]

Hi @johnt75 

I Agree. But i have 100 columns. when i use DAX 100 extra columns will create over there(through using SWITCH/IF) is there any other option to write mesuare for all togather in one shot?

[mwegener]

Hi @prudhvi_kumar 

do you mean something like this?

Col A = IF(CONTAINS('Table A','Table A'[A], TRUE()),"yes","no")  

[prudhvi_kumar]

hi @mwegener 

I Agree. But i have 100 columns. when i use DAX 100 extra columns will create over there(through using SWITCH/IF) is there any other option to write mesuare for all togather in one shot?