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 All
I am trying to create a measure that shows me overdue invoices between 0-30 day, 31-60 etc. I can not create calculated columns (which I am used to), so having to create measures. I have a measure for the days overdue:
Days = SUMX(INVOICES,DATEDIFF(INVOICES[INVOICE_DUE_DATE],TODAY(),DAY))
I now want to create a card that shows that total owing for 0-30 days.
I have managed to create a measure for a specific day overdue., in this case 9 days, but how can I do between 0-30 days?
0-30 = SUMX(FILTER(INVOICES,INVOICES[Days]=9),INVOICES[REM_BALANCE])
I have exhausted google!
Thanks
Solved! Go to Solution.
I have found the solution:
I have found the solution:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
68 | |
67 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |