Forum Discussion
How to add text condition in Switch
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"
Community ChampionHi 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",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.
- az38
Anonymous
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 Hi AZ - Yes, if you are talking about including it in the measure you created, it is there, but that is the result I am getting.
Here is another example. This time in June. It is showing that this opportunity's estimate ship date has "passed already" but it still about 20 days into the future.
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"