Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
100 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |