Forum Discussion
Measure ouput help
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!
Hi, Anonymous
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.
3 Replies
Hi, Anonymous
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.
Anonymous , 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-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
