Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    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.