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 have a calculated column with 5 variables inside. Each row is satisfying only 1 variable which means other 4 return blank.
Is there an easy way to actually return only that one variable that is not empty. This calculated column is used to split the dataset in 5 categories.
Thank you!
Solved! Go to Solution.
Hey @MrMP ,
I think the best way to do that is with a SWITCH and TRUE:
myColumn =
VAR Var1 = BLANK()
VAR Var2 = BLANK()
VAR Var3 = 1
VAR Var4 = BLANK()
VAR Var5 = BLANK()
RETURN
SWITCH(
TRUE(),
Var1 <> Blank(), Var1,
Var2 <> Blank(), Var2,
Var3 <> Blank(), Var3,
Var4 <> Blank(), Var4,
Var5 <> Blank(), Var5
)
Hey @MrMP ,
I think the best way to do that is with a SWITCH and TRUE:
myColumn =
VAR Var1 = BLANK()
VAR Var2 = BLANK()
VAR Var3 = 1
VAR Var4 = BLANK()
VAR Var5 = BLANK()
RETURN
SWITCH(
TRUE(),
Var1 <> Blank(), Var1,
Var2 <> Blank(), Var2,
Var3 <> Blank(), Var3,
Var4 <> Blank(), Var4,
Var5 <> Blank(), Var5
)
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |