Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
49
Views
Topic starter
I have daily volume figures on a table for 2 years. Can I set up a Field Value on the daily total to Create a 3 day average, or do i need to do the calculation 1st.
Posted : 19/05/2022 4:25 pm
Hi Eileen,
If you're using Power Pivot then you could write a DAX measure for the 3 day average. If you're using regular PivotTables then you'd need to add this calculation to the source data. However, if you have multiple values per day in the source data then it'll be tricky because the PivotTable will then aggregate the averages from the source and that's probably not what you want.
Hard to say without seeing an example file.
Mynda
Posted : 20/05/2022 7:46 pm
