Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Prior Year Data - Multiple Months

Hey, hoping someone can point me in the right direction here. I have a table of financial data, with posting month, and a month mapping table which will drive the filter of the financial data table. ...
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    Make sure you have a Date table and mark it as a Date table, then you can take advantage of the Time Intelligence functions to easily do your calculation with DATEADD(), SAMEPERIODLASTYEAR(), etc.  Please see this post for detailed explanation.

     

    https://exceleratorbi.com.au/dax-time-intelligence-beginners/

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

     

     

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Make sure you have a Date table and mark it as a Date table, then you can take advantage of the Time Intelligence functions to easily do your calculation with DATEADD(), SAMEPERIODLASTYEAR(), etc.  Please see this post for detailed explanation.

 

https://exceleratorbi.com.au/dax-time-intelligence-beginners/

 

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    you are my hero buddy! Had not heard of SAMEPERIODLASTYEAR(), but it works so well! thanks so much for your help