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,

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]

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