Historical data from measure output

[Anonymous]

Hi everyone,

I'd like to record the output of a measure and get the historical data of said measure, to use for visualization. For example, I calculate the avergage turnover per day with a measure. I'd like to have this output be stored in a table, with the date of today. 

Does anyone have any idea how I can achieve this? Thanks in advance!

[Jihwan_Kim]

Hi, @Anonymous 

Please correct me if I wrongly understand your question.

The below shows Date-table and Sales-table that are not connected.

By writing a measure shown in the picture, the historical data that is before the selected date can be shown.

I think, this can be used as a stored data inside your other measure by using it together with VAR.

If it is OK with you, please kindly share your sample pbix file, then I can try to come up with more accurate measures.

thank you.

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.