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...
Aburar_123's avatar
Aburar_123
Solution Supplier
4 years ago

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