Historical Debt Trend

[rod_puente]

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

[v-pgoloju]

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

[v-pgoloju]

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

[v-pgoloju]

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

[rod_puente]

LINK:  https://docs.google.com/spreadsheets/d/15s6dLHWzmpLMpkUgaVUNUtDfPX0YG5N5/edit?usp=sharing&ouid=10417...

[Ashish_Excel · Accepted solution]

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.

[Ashish_Excel]

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]

Hi Ashish

Link: 

Archivo 

Regards

Rodrigo Puente