Forum Discussion
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 possible to create any measure for the same.
7 Replies
do you mean something like this?
Col A = IF(CONTAINS('Table A','Table A'[A], TRUE()),"yes","no")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?
Can you use power query instead of DAX? You could transform the data during load changing TRUE to Yes and FALSE to No.
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?
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.
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
