cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

var + return multiple

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

 

Colonne_tes =
var __tisDate = 'DimDate'[FullDateAlternateKey]
var __lastDateinTable = MAX(DimDate[FullDateAlternateKey])
var __DaybeforToday = __lastDateinTable - 1
return
IF(
1 * (__tisDate = __lastDateinTable),
2 *(__lastDateinTable = __DaybeforToday)

)
 
the If return nothing, 

 

1 ACCEPTED SOLUTION
Super User II
Super User II

Hi @rayloubayi 

 

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?

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

View solution in original post

2 REPLIES 2
Super User II
Super User II

Hi @rayloubayi 

 

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?

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

View solution in original post

hello using @Mariusz  Answer here is the solution may be it will help somebody 

Colonne_11 =
var __tisDate = 'DimDate'[FullDateAlternateKey]
var __lastDateinTable = MAX(DimDate[FullDateAlternateKey])
var __DaybeforToday = __lastDateinTable - 1
var __Daybeforyesterday = __DaybeforToday - 1
return
SWITCH(
TRUE(),
__tisDate = __lastDateinTable, 1,
__tisDate = __DaybeforToday,2,
__tisDate = __Daybeforyesterday,3,
4
)
 
 
this gives you 
05/03/2020 1
04/03/2020 2
03/03/2020 3
02/03/2020 4
01/03/2020 4

thanks to @Mariusz  for the help 🙂

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors