Forum Discussion

madlfc87's avatar
madlfc87
Icon for Helper I rankHelper I
2 years ago
Solved

Average per day by month

Hello,   I would like to calculate the average per day for each month for the following measure.   Days Test = COUNTX(ADDCOLUMNS(GENERATE('tblHolidayDates_all locations',DATESBETWEEN('Calendar'[...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
but I believe it averages over all the rows of the month not all the days.

Add an intermediate step with SUMMARIZE or SUMMARIZECOLUMNS that pre-aggregates your data by day.

madlfc87's avatar
madlfc87
Icon for Helper I rankHelper I
2 years ago

Thank you for your reply. Could you be a bit more specific please?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Please provide a smaller sample file. Yours is way too big.

    • madlfc87's avatar
      madlfc87
      Icon for Helper I rankHelper I
      2 years ago

      lbendlin 

      The below is a screenshot of the table tblHolidayDates_all locations

       

       

      and the below is a screenshot of the table Calendar

       

      Appreciate your help

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        Touche.  I should have specified that I cannot work with screenshots. Please provide sample data that fully covers your issue but not more, in a usable format.
        Please show the expected outcome based on the sample data you provided.