Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

replace numbers to yes and No

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
Show and Tell
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    5 years ago

    Hi Anonymous ,

     

    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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 

Leonardo_DP's avatar
Leonardo_DP
Frequent Visitor
5 years ago

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.