Forum Discussion
MAT & MAT Prior has same value using SAMEPERIODLASTYEAR
Hi Expert I am still learning in DAX and trying to calculate MAT, PYMAT this is the formula I use MAT = CALCULATE( AVERAGE(data[value]), DATESINPERIOD('Date'[Date],LASTDATE('Date'[Date]),...
Hi amitchandak , I found the MAT and MAT Prior show the same value when it aggregated (right side)
but show the correct figure when it show at month/year level (left side)
how to make the formula also work for aggregated (left side)?
Thank you 🙂
Hi PERMATA ,
Could you please provide your pbix file with the latest version? Later will check it and give you a suitable soltuion. Thank you.
Best Regards
Hi Anonymous
I upload the .pbix here https://drive.google.com/drive/folders/1XmREz69UM0m31gVIPy-9BvGnnGEIDMXd
Thank you
Hi PERMATA ,
It seems that I don't have the proper access to your shard file. Could you please grant me the proper access? Thank you.
Best Regards