Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 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
9 years ago

Still looking for help on this

Thyago_Rezende's avatar
Thyago_Rezende
Icon for Resolver I rankResolver I
9 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,