Forum Discussion

PERMATA's avatar
PERMATA
Frequent Visitor
3 years ago

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]),...
Need Help
PERMATA's avatar
PERMATA
Frequent Visitor
3 years ago

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 🙂

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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