var + return multiple

[Anonymous]

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, 

[Mariusz · Accepted 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?

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn

[Anonymous]

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 🙂