Forum Discussion

rnambiar's avatar
rnambiar
Frequent Visitor
1 year ago
Solved

Time Shifted Measures

Hi, I have 5 measures that show AR outstanding - Current, 30 Days, 60 Days, 90 Days, 180 Days.  This calculated based on Today's date.  The measures are in columns.  I would like to be able to show ...
Need Help
Show and Tell
Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

Cannot understand your question.  Please share the file.  Show the problem and the expected result.

rnambiar's avatar
rnambiar
Frequent Visitor
1 year ago

Hi Ashish,

Thanks for looking in to this - much appreciated.  

I have not yet created any file as I have been struggling to understand how to do this.  The output is supposed to look like the table shown above.

 

For more context - We have invoices that an invoice date and amount due.  So if the invoice date was 07/14/2025 and the amount was $100 - then that amount would be in the 1-30 day coulmn.  Today, Current date, (08/14/2025) - 07/14/2025 is less than 30 days.    This would show in the Today row under 1-30.  Now, lets say we look at this invoice a month later on 09/14/2025 then the Today row under 31-60 would show the $100.  However, in the Row Today-30 we would show the $100 becasue at point in time the invoice was only 30 days aged. 

 

I hope this makes sense.  I am essentially trying to look back in time to see how things have changed.

 

Thanks,

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    Hi,

    I will need a file to work on.  You may share an MS Excel file with your formulas written there.  I will try to translate those formulas into DAX measures.