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'm new in DAX, and I'm having a problem in counting the number of days with a condition. I need a measure that will count the days passed from the slicer date where the GL OB is more than the Amort OB and will stop the count if there will be a date where the Amort OB is more than equal the GL OB. Please see the table below (The No. of days column is the result of the measure I needed):
Date | Amort OB | GL OB | NO OF DAYS |
Sep-19 | 10,000 | 12,000 | 0 |
Oct-19 | 8,000 | 8,000 | 0 |
Nov-19 | 6,000 | 8,000 | 31 |
Dec-19 | 4,000 | 8,000 | 61 |
Could not solve in one measure. Created a column and measure
First column: If amount GL OB is greater then Amort OB
Can this be solve without adding a column?
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |