replace numbers to yes and No

[sanjay009]

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

[V-lianl-msft · Accepted 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.

[parry2k]

@sanjay009 what you mean your column names are dynamic? Provide a bit more context. Your original question is answered by @Leonardo_DP 

[sanjay009]

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]

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.

[Leonardo_DP]

A simple if condition like if number = 0 then no else yes would work.

[sanjay009]

The column names are dynamic