Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to add text condition in Switch

dd   Hello - I need to add another condition to this statement, but not sure how.   I need to add: allopps-products[status]="open" as one of the conditions. But it won't let me.   What do I ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    az38  I got it to work using this: 

     

    TRUE(),
        DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY) > -1 &&  DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY) > -20, "Passed already"
Anonymous's avatar
Anonymous
Not applicable
6 years ago
Anonymous 
 
You can add  allopps-products[status]="open" using  && notation
 
 
SWITCH(
    TRUE(),
    MAX('AllOpps-Products'[Prob.])  = 80 && allopps-products[status]="open" , "30 Days",
    DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY)> 90, "Older than 90",
    DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY)> 60, "Older than 60",
    DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY)> 30, "Older than 30",
    DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY)> 15, "30 Days",
    
)
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)