Solved: Creating a flag

linlook · ‎08-24-2020

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 · ‎08-24-2020

@linlook -

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎08-24-2020

@linlook -

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

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

amitchandak · ‎08-24-2020

@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"

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube