Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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'[...
Need Help
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    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

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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 🙂