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 all,
Please could you advise the DAX for below query
IF
THEN 1
ELSE 0
Thanks,
Henry
Solved! Go to Solution.
Should work like this:
Simply remove the equal operator from the second part of the two conditions, the ones that check that date is <=today. Just put inferior to today.
Should work like this:
That only returns values that are both those statements
How do I return values
The double pipe is equivalent to the OR operator. It should return 1 if either one of the mentioned conditions is true. Are you sure it's interpreting it as an AND condition? It would be very weird
Hi @Anonymous
I can't work out why it's returning 1 for the below?
None of the dates are -7 from today?
I'm sorry I didn't understand that you also had future Dates in the target columns. You need to modify the code in this way:
Thanks @Anonymous
That's worked.
Last point - how can I ammend so it returns the last 7 days NOT including today?
Cheers,
Henry
Simply remove the equal operator from the second part of the two conditions, the ones that check that date is <=today. Just put inferior to today.
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.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |