Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
My first ever question on this forum. I am relatively new to Power BI and would really appreciate support from the experts in the community.
I am trying to extract the column names for each values of 'X'. I need to look at columns B to J.
Is there a way to do this in power BI.
Appreciate any help. I have attached a screenshot to help understand, let me know if you need more information.
Many Thanks
Azhar
Solved! Go to Solution.
This is not the perfect solution but the best I could work out so far.
you can select the all the columns where you need to find the value 'X', then in Query Editor unpivot these column to row data like picture below, click "Close & Apply".
then create new column1
Column1= IF [Value]="X" then [Attribute] ""
Finally, you can create calculated table using DAX below.
This is not the perfect solution but the best I could work out so far.
you can select the all the columns where you need to find the value 'X', then in Query Editor unpivot these column to row data like picture below, click "Close & Apply".
then create new column1
Column1= IF [Value]="X" then [Attribute] ""
Finally, you can create calculated table using DAX below.
anyone please? or I take it, it is not possible ?
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |