Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have a formula that does not work properly.
I added a new custom column and put this as the criteria.
So I want the value in the column to be set to 1 if shortlist = 0 and duedate is 3days from now or less. But that does not work all the time. Do you see any obious errors here?
Solved! Go to Solution.
Can you provide an example of where you are seeing an undesirable result and what you would expect the result to be?
For example, for today of 3/3/2020 if you were to tell me that you wanted 2/28/2020 to have a 1 I would say use -4 instead of -3
Can you provide an example of where you are seeing an undesirable result and what you would expect the result to be?
For example, for today of 3/3/2020 if you were to tell me that you wanted 2/28/2020 to have a 1 I would say use -4 instead of -3
hey @Greg_Deckler
Thanks for answering. Yeah, I got the minus all wrong, I was looking at dates 3 days ago, but I should have been looking for dates IN three days. So I just removed the - sign and it worked 🙂
Thanks for your tip about the EARLIER command! 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.