Forum Discussion
Calculate and track daily average
Hi,
I have a dataset that changes everyday. I would like to calculate the daily averages each morning and track this on a chart that will show the day to day trending Would like to seek some help no how i can achieve this?
Thank You.
aikkoon , is data getting overwritten daily, if yes refer to the links below for DAX append, else Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
1 Reply
- amitchandak
Super User
aikkoon , is data getting overwritten daily, if yes refer to the links below for DAX append, else Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/