Forum Discussion
Monthly Average that Changes Based on Date Selection
Hi everyone, I have my monthy average measure for my Sales found in my fSales table, but I need to ammend it so that is automatically averaging based on what dates I am currently filtering/includ...
Hi,
This measure pattern should work
Average monthly sales = AVERAGEX(VALUES(ddate[Month name]),[Total sales])
I have assumed that Total sales is a measure that you have written. To your slicer, drag Month name from the ddate table.
Ashish_Mathur
Super User
Super UserHi,
This measure pattern should work
Average monthly sales = AVERAGEX(VALUES(ddate[Month name]),[Total sales])
I have assumed that Total sales is a measure that you have written. To your slicer, drag Month name from the ddate table.