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 there,
I have the following scenario:
For the measure Historical Overdue I need a measure that counts all values for which the Due Date was exceeded at that moment and which were not yet set (fully paid and written off), the latter can be seen from the closed date. So the date> Due Date <Closed Date, if the Closed date is 1-1-1900 then the post is still open and therefore only date> Due date
My measure looks like this:
Solved! Go to Solution.
Please try this instead
Historical Overdue Receivable =
VAR CurrentDate =
MAX ( 'Dimension Date'[DateValue] )
VAR Overdue =
CALCULATE (
SUM ( 'Fact Receivable'[Receivable Amount EUR] ),
ALL ( 'Dimension Date'[DateValue] ),
'Dimension Date'[DateValue] <= CurrentDate,
FILTER (
ALL (
'Fact Receivable'[Receivable Due Date],
'Fact Receivable'[Receivable Closed Date]
),
'Fact Receivable'[Receivable Due Date] > CurrentDate
|| YEAR ( 'Fact Receivable'[Receivable Closed Date] ) = 1900
),
USERELATIONSHIP ( 'Dimension Date'[DateValue], 'Fact Receivable'[Receivable Due Date] )
)
RETURN
Overdue
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Please try this instead
Historical Overdue Receivable =
VAR CurrentDate =
MAX ( 'Dimension Date'[DateValue] )
VAR Overdue =
CALCULATE (
SUM ( 'Fact Receivable'[Receivable Amount EUR] ),
ALL ( 'Dimension Date'[DateValue] ),
'Dimension Date'[DateValue] <= CurrentDate,
FILTER (
ALL (
'Fact Receivable'[Receivable Due Date],
'Fact Receivable'[Receivable Closed Date]
),
'Fact Receivable'[Receivable Due Date] > CurrentDate
|| YEAR ( 'Fact Receivable'[Receivable Closed Date] ) = 1900
),
USERELATIONSHIP ( 'Dimension Date'[DateValue], 'Fact Receivable'[Receivable Due Date] )
)
RETURN
Overdue
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
106 | |
105 | |
79 | |
69 | |
61 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
70 |