Forum Discussion
Helper IHistorical Debt Trend
Dear All
Pls your help.
I need to know how I can generate a historical debt trend by week and year.
For example, if we're in week 1, I need to calculate the total and past-due debt for that week. I'm going to consider 05/01/2025 as the deadline. However, when I look at subsequent weeks, I shouldn't consider the past-due debt from week 1, because the debt itself may not exist for that week 2.
In short, I need to generate indicators per week.
Regards
Rodrigo Puente
Hi,
In the Calendar table, just get the correct week numbers - for now, i do not have ISO week numbers there. Download PBI file from here.
7 Replies
Ashish_ExcelSolution Supplier
Hi,
Share the download link of the Excel file with your Excel formulas already written there. I will conver those Excel formulas to DAX measures.
rod_puente
- Ashish_Excel
Hi,
In the Calendar table, just get the correct week numbers - for now, i do not have ISO week numbers there. Download PBI file from here.
Hi rod_puente,
Thank you for reaching out to the Microsoft Fabric Forum Community. And also thanks to Ashish_Excel for prompt and helpful solution.
Just following up to see if the solution to create DAX measures provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.
Best regards,
Prasanna Kumar
Hi Ashish_Excel,
Just following up to see if the DAX measure worked as expected for your scenario. Were you able to get the desired results using the suggested approach?
If you need any further clarification or run into any issues, feel free to reach out—we’re happy to help.
Warm regards,
Prasanna KumarHi rod_puente,
Just a gentle reminder has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.
This not only closes the loop on your query but also helps others in the community solve similar issues faster.
Best,
Prasanna Kumar
