Creating a flag

[linlook]

Hi all,

I'm new to Power BI Desktop.

I want to create a flag in column in my data table that shows only "1" or "0" based on following condition:

If Fault = "1P_MH" or "2P_MH" and Status = "1", Then Flag = "1", otherwise "0"

Fault	Status	Flag
1P_MH	0	0
1P_MH	1	1
2P_MH	0	0
2P_MH	1	1

Any advices are welcome.

Thanks!

Best Regards

[Greg_Deckler · Accepted solution]

@linlook - 

Flag Column = 
  SWITCH(TRUE(),
    ([Fault] = "1P_MH0" || [Fault] = "2P_MH0") && [Status] = 1,1,
    0
  )

[amitchandak]

@linlook ,new column

In DAX

flag = if (([Fault] = "1P_MH" II [Fault] = "2P_MH") && [Status] = "1" ,  "1" , "0")

or

flag = if (([Fault] = "1P_MH" II [Fault] = "2P_MH") && [Status] = "1" , 1, 0)

in power query M

flag = if ([Fault] = "1P_MH" or [Fault] = "2P_MH") and [Status] = "1" then  "1" else "0"