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 Daywithoutserve= [Días sin pedir]
    var Status=
        SWITCH([Días sin pedir],
                Consumo[Consumo diario en el último años]<=30, "No servir",
                Consumo[Consumo diario en el último años]<=60, "Posible",
                Consumo[Consumo diario en el último años]<=90, "Servir"
                )
return  
Estado
 
Power Bi says is impossible to the switch funtion compare between Integer and TRUE/FALSE values, that I should try use FORMAT or VALUE funtion to conver the data. But I have no idea how to use these funtioncs.

Could someone help me please?
  • 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?

2 Replies

  • 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?

  • 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