Forum Discussion

linlook's avatar
linlook
New Member
6 years ago
Solved

Creating a flag

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"

 

FaultStatusFlag
1P_MH00
1P_MH11
2P_MH00
2P_MH11

 

Any advices are welcome.

 

Thanks!

 

Best Regards

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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"

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    linlook - 

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