March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I have data as below. want to replace the 0 to No and any number to Yes
ID | Type1 | Type2 |
A0001 | 2 | 3 |
A0002 | 1 | 4 |
A0003 | 0 | 6 |
A0004 | 12 | 0 |
Thanks you
Solved! Go to Solution.
Hi @sanjay009 ,
Try to select "ID" column and unpivot other column.
Then create a measure and show it in matrix visual.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @sanjay009 ,
Try to select "ID" column and unpivot other column.
Then create a measure and show it in matrix visual.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@sanjay009 what you mean your column names are dynamic? Provide a bit more context. Your original question is answered by @Leonardo_DP
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Column names will be changing every month. In below repsonse how i use this ( is it a measure or Conditional column)
if number = 0 then no else yes
I think the best way without complicated formulas it's gonna be:
on power query select the id column (my guess is that's not gonna change) then select the option change other columns to lines, it's gonna create 2 columns, one with the type (name of the column) and other with the value.
then you can create a conditional column with the formula.
srry for language mistakes, it's not my first language.
A simple if condition like if number = 0 then no else yes would work.
The column names are dynamic
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
86 | |
83 | |
72 | |
49 |
User | Count |
---|---|
167 | |
149 | |
98 | |
73 | |
57 |