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?

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
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?