Measure ouput help

[Sohan]

I have a measure that calculates the average turnover per day for a doctor. Every time I update the data, the measure gives a new value. 

I update the data once a day. I want the output of the measure to be placed in a table, with the date of the output. This way, I can see how the average turnover per day changes over time. 

This is how I'd like the output to be saved each day:

Thanks in advance!

[Jihwan_Kim · Accepted solution]

Hi, @Sohan 

I am not sure if you want to create a new table or a table visualization + other visualizations.

Please check the below link that is what I have created by using my sample data.

measures for the calculated table and calculated measure are in the file.

Thank you.

https://www.dropbox.com/s/mvh6n80ba4zglit/Sohan.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[Sohan]

Thank you so much! This worked for me.

[amitchandak]

@Sohan , There is an approach DAX append, that might help. Can you check if these two blogs can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/