Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help calculating daily average

Daily Average Sales= AVERAGEX(KEEPFILTERS(VALUES('LNApps_AppDateDim'[ActualDate])),CALCULATE(SUM('LNApps_Facts'[Total_Sales]))) I am trying to get the daily average sales, but the numbers the formu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Still looking for help on this

  • Thyago_Rezende's avatar
    Thyago_Rezende
    Resolver I
    8 years ago

    Hi,

     

    Try to create expression table using SUMMARIZE function within AVERAGEX (in first parameter) that contain the granularity by months.

     

    Example: if your facto_table shows sales day-by-day, so you should create new table (within averagex) with SUMMARIZE function that contain sales agregated by months only.

     

    Regards,