Forum Discussion
Historic data
Hi all,
I'm quite new to using Power Bi and hence I have some questions.
I have my Power Bi connected to Dynamics 365 Sales Solution to display our pipeline including a lot of additional data.
I am searching for a solution, where I can display historical data as well.
For example, I have today´s numbers for our total expected turnover, but I would like to have the historical numbers in a graph, to display the development of the pipeline.
Is there an easy way to do this, with Power Bi?
Thank you in advance.
2 Replies
Anonymous , do you want to create a snapshot, if yes, check for
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/amitchandak that might do the trick.
I just need a solution, where I can, let´s say weekly, take a snapshot of the amount in our pipeline, so that I can build a graph showing the development.
I´ll give it a look - thanks.
