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 the same measures but from Today-30, Today-60, Today-90 and so on but in rows.  It should look something like this.  It will be a Matrix. 

 Current+1 - 3031 - 6061 - 9091 - 120120 - 180180+
Today540,531.681,773,814.49864,748.27476,479.97153,081.91117,694.87422,080.31
Today-30 86,818.71    67,796.80 26,819.50 92,025.13 80,835.81 68,443.23 53,388.23
Today-60 91,825.32    95,221.15 85,335.61   4,708.95 97,594.27 26,564.96 48,508.91
Today-90 33,293.14    70,069.21   4,662.72 26,425.48 94,947.52 95,382.12 55,616.90

Any thoughts or help is greatly appreciated.

Thanks,

 

 

 Current+1 - 3031 - 6061 - 9091 - 120120 - 180180+
Today540,531.681,773,814.49864,748.27476,479.97153,081.91117,694.87422,080.31
Today-30 86,818.71    67,796.80 26,819.50 92,025.13 80,835.81 68,443.23 53,388.23
Today-60 91,825.32    95,221.15 85,335.61   4,708.95 97,594.27 26,564.96 48,508.91
Today-90 33,293.14    70,069.21   4,662.72 26,425.48 94,947.52 95,382.12 55,616.90
Need Help
Show and Tell

9 Replies

  • 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.

  • rnambiar's avatar
    rnambiar
    Frequent Visitor
    1 year ago

     Hey Ashish,

    I tried to attach the excel file to this and got this error.

     

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi rnambiar 

    I wanted to check if you had the opportunity to provide the requested information. Please feel free to contact us if you have any further questions.


    Thank you.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    1 year ago

    Hi rnambiar ,

    May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.


    Thank you

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    11 months ago

    Hi rnambiar ,

    As we haven’t heard back from you, we wanted to kindly follow up to check if the issue still persists, If yes kindly try sharing the requested sample data so that we can take a look. Please feel free to contact us if you have any further questions.

     

    Thanks and regards