title: DAX Calculate Monthly Average
body: <p>I am trying to create a measure to calculate a monthly average from a set of data that was collected every 15 minutes.  I am newer to DAX and am just unsure how to intelligently filter by month without hard setting in the month ID #. The formula I am trying is:</p>
  
  <p>Average Monthly Use:=AVERAGEX(VALUES('Lincoln Data'[Month]),[kWh])</p>
  
  <p>Where kWh is a measure of the total usage in a column</p>
  
  <p>Thanks in advance</p>
  
  <p>DVDV</p>