Forum Discussion
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 ...
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
Community Champion
Community ChampionAnonymous
it will work only if you previously add row with 0 value comparision as in my example
DATEDIFF(MAX('AllOpps-Products'[Est.Ship]),TODAY(),DAY)> 0, "0 Days",
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"