Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have account receivables consisting of invoices, their close/pay date (can be blank), due date (not blank), and a transaction date among other fields.
I have already calculated a static overdue/not overdue status field based on today's date. However, I need to create a dynamic overdue/not overdue status measure because I want to look at the status of an invoice based on the last date of the date period that I select/filter on.
I am using a date period slicer (between).
I did manage to fetch the last date of the period with
"Period End-Date = CALCULATE(MAX(Calendar[Date]), ALLSELECTED(Calendar[Date]))"
Then I tried creating the dynamic status field as following:
It worked for the majority of rows, but some rows receive the wrong status, "Not Overdue" even if the due date is behind the period end-date, for instance due date - 30/12/2022 vs period end-date - 31/12/2022.
What could I be doing wrong? Sadly, I cannot share the data.
Thank you in advance!
Best regards