Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Switch Funnction - calculate Status

Hi Community,

below my table.

I currently calculate my status according to the following logic.
 If I can also check if there is "7.done" in the column-upcoming milestone, then I would also like to have in the status "done" in it.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hello @Lachsforelle12 ,

    Simply add the criteria to the switching function:

    Status=
SWITCH(
TRUE(),
'MB final'[upcoming Milestone]="7.done","done",
'MB final'[Datediff]<=0,"1.on Time",
'MB final'[Datediff]>=1&&'MB final'[Datediff]<=3,"2.delayed 1-3 month",
'MB final'[Datediff]>=4&&'MB final'[Datediff]<=6,"3.delayed 3-6 month",
'MB final'[Datediff]>=7,"3.delayed >6 month"
)


    Saludos
    Kelly

    Have I answered your question? Mark my position as a solution!

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Anonymous , As this as the first condition in Switch

     

    [upcoming milestone] ="7.done" , "Done",

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hello @Lachsforelle12 ,

    Simply add the criteria to the switching function:

    Status=
SWITCH(
TRUE(),
'MB final'[upcoming Milestone]="7.done","done",
'MB final'[Datediff]<=0,"1.on Time",
'MB final'[Datediff]>=1&&'MB final'[Datediff]<=3,"2.delayed 1-3 month",
'MB final'[Datediff]>=4&&'MB final'[Datediff]<=6,"3.delayed 3-6 month",
'MB final'[Datediff]>=7,"3.delayed >6 month"
)


    Saludos
    Kelly

    Have I answered your question? Mark my position as a solution!