Forum Discussion

Maricel's avatar
Maricel
Frequent Visitor
3 years ago
Solved

How to FORMAT or VALUE my SWITCH formula?

Hi everybody,   I need to classified the difference between 2 dates: today and the last order date. Ir order to do so, I was trying to use this DAX formula:   Serves Clasification =     var Da...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Maricel 

    is this a measure or a calculated? The variable Daywithoutserve is not used. The syntax of the SWITCH statement is not correct, normally it should be  SWITCH ( TRUE (), ...... however, it is not clear what are you trying to achieve by inserting the [Días sin pedir] measure into the switch statement. What is Estado?

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi， Maricel 

[Días sin pedir] is of integer type and result of Consumo[Consumo diario en el último años]<=??  is of type boolean, so you can't compare them.

If [Días sin pedir] is the difference between the two dates, you can try something like:
Measure:

Serves Clasification =
VAR Daywithoutserve = [Días sin pedir]
VAR Status =
    SWITCH (
        TRUE (),
        Daywithoutserve <= 30, "No servir",
        Daywithoutserve <= 60, "Posible",
        Daywithoutserve <= 90, "Servir"
    )
RETURN
    Estado

Best Regards,
Community Support Team _ Eason