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"
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Anonymous 

smth like

DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY)> 0, "0 Days",
DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY)> -15, "Passed already",
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks AZ.  az38     But I am getting some strange results.   May 29 is two days away, but it is shows "pass already" as a result.     The table on the left using the formula.   The table on the right is a list of opportunities and their estimated close/ship date.