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.
hello
can someone help me please
i'm woindering if it's possible to have in a return clause multiple lignes
here is the code that i'm wrinting
Solved! Go to Solution.
Hi @Anonymous
if are you looking to pass multiple logical tests, then you can use SWITCH
columns =
SWITCH(
TRUE(),
'Product'[Color] = "Red", 1,
'Product'[Color] = "Blue", 2,
'Product'[Color] = "Black", 4,
3 --else
)
btw, your question is DAX related did you wanted to recreate it in Power Query?
Hi @Anonymous
if are you looking to pass multiple logical tests, then you can use SWITCH
columns =
SWITCH(
TRUE(),
'Product'[Color] = "Red", 1,
'Product'[Color] = "Blue", 2,
'Product'[Color] = "Black", 4,
3 --else
)
btw, your question is DAX related did you wanted to recreate it in Power Query?
hello using @Mariusz Answer here is the solution may be it will help somebody
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |