Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@linlook -
Flag Column =
SWITCH(TRUE(),
([Fault] = "1P_MH0" || [Fault] = "2P_MH0") && [Status] = 1,1,
0
)
@linlook -
Flag Column =
SWITCH(TRUE(),
([Fault] = "1P_MH0" || [Fault] = "2P_MH0") && [Status] = 1,1,
0
)
@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"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |