Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi all,
I have a scenario where I need to have a column (or measure?) that calculates a DateDiff between an invoice due date and date input by a user to determine how many days past due is an invoice related to that user key date. For example given the sample data and a user keys in date 9/1/2019 they would get the Days Past Due column highlighted in red below. The Issue here is getting that key date to be used within the dashboard to interact with that table dynamically to deliver the results below. Any thoughts?
| Invoice | Due Date | Balance | Days Past Due |
| 1001 | 9/5/2019 | $40 | 4 |
| 1002 | 9/18/2019 | $80 | 17 |
| 1003 | 9/26/2019 | $100 | 25 |
Thanks!
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |