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.
Hello all,
I have a table of Course dates with columns Order Date, Sales Amount, etc. for purchasing other products before or after a course. I calculated a Date Difference between [Course Date] and [Order Date] in a separate column using DATEDIFF.
Now I want to attribute sales after the course to that course if the sale has happened not later than 90 days after the course, otherwise, I have different conditions.
I have this formula:
Solved! Go to Solution.
This is what I see.
the first condition says "give me all results that are zero, and at the same time are less than 90". This will return no result as there is no number that can be both.
the second, third conditions have cross over. Eg -45 satisfies both 2 and 3.
Of course! Thanks for pointing this to me, I need more sleep, haha.
This is what I see.
the first condition says "give me all results that are zero, and at the same time are less than 90". This will return no result as there is no number that can be both.
the second, third conditions have cross over. Eg -45 satisfies both 2 and 3.
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 |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |