Forum Discussion
New table - column header to line value
Hi,
I'd like to transform a calculated table to an additional calculated table, which is supposed to serve as baseline for a waterfall.
Therefore in the new table I want to use the column header as line value and count a specific value in the next two columns.
I'm not able to find any solution in DAX for my issue.
Thank you in advance,
Nice regards
5 Replies
ryan_mayuSuper User
could you pls provide the sample data (not the screenshot) and the expected output?
how to calculate hit or win?
Hi Ryan,
Hit or win will be a count with a filter.
100% - Win
0% - Hit
Unfortunanetly I cannot easily provide the sample data.
Nice regards,
Daniel
- Ashish_Mathur
Hi,
Not sure of where you get the HIT and WIN from but you should start with "Unpivot Other columns" in the Query Editor.
Hi Ashish,
Hit or win will be a count with a filter.
100% - Win
0% - Hit
I read about Unpivot Other columns, but thought its not possible if the table is already calculated in powerbi.
Nice regards,
Daniel
- Ashish_Mathur
"Unpivot Other columns" has to be run on the raw dataset. I shared this approach because the first screenshot you shared is of the raw dataset (not that of a calculated Table i.e. the result of a DAX calculated table formula).
