Forum Discussion
PERMATA
3 years agoFrequent Visitor
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]),...
Anonymous
3 years agoNot applicable
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
PERMATA
3 years agoFrequent Visitor
Hi Anonymous
Please find the .pbix here 🙂
https://drive.google.com/drive/folders/1XmREz69UM0m31gVIPy-9BvGnnGEIDMXd
thank you