Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
115 | |
100 | |
73 | |
67 |