Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
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.
Regards
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
87 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |