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]),...
PERMATA
3 years agoFrequent Visitor
Hi Anonymous
I upload the .pbix here https://drive.google.com/drive/folders/1XmREz69UM0m31gVIPy-9BvGnnGEIDMXd
Thank you
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