Solved: Re: Historical Debt Trend

rod_puente · ‎06-10-2025

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

Ashish_Excel · ‎06-11-2025

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.

View solution in original post

Anonymous · ‎06-19-2025

Hi @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

Anonymous · ‎06-16-2025

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 Kumar

Anonymous · ‎06-12-2025

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