Forum Discussion

Jacy's avatar
Jacy
Frequent Visitor
9 years ago

add up previous period value

I need to check if a value is greater than the value of the previous month, these values ​​are in a year / month dimension matrix.
I already tried the calculation Test = CALCULATE ([Vlr Expenses]; PARALLELPERIOD (LASTDATE ('Calendar'); - 1; MONTH)), but did not work.

Need Help

1 Reply

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi Jacy,

     

    Could you post your table structures with some sample data which can help us reproduce the issue, so that we can help further investigate on it? 

     

    It's better to share a sample pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. :smileyhappy:

     

    Regards