saving values out of a query in a data table

[SadStatue]

Hi Guys,

I'm building a report, and I have a query that bring me the most current situations of due invoices. beside showing the current situation I want to show the historical trends as well.

How can I get the values of the query each day and save it in another table in my data model with date, so I can plot it based on the date?

e.g. the query run today(25/02/2021) and bring back A=1000200

I want to keep this value in another table like this:

Date	amount
24/02/2021	1000000
25/02/2021	1000200

Cheers,

[amitchandak · Accepted solution]

@SadStatue , I think you want to store past data so that you can have a snapshot past when data is refreshed

refer if the approach of these 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/

[SadStatue]

Hi @amitchandak ,

Thank you for your response. Is the incremental refresh just work for fully folded queries? as I have some issue in implementing it.

Cheers