Forum Discussion
Monthly snapshot capturing
Hi All, I have an excel sheet which keeps dynamically changing and I need to capture the monthly changes in numbers and analyse the trend. How can this be possible in power bi. Appreciate your ...
kpraveen1397,
You can begin with creating historic data table following the guide in the following blog and video. Then calculate monthly change based on the historic data in Power BI Desktop.
https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/
https://www.youtube.com/watch?v=xDVUUcbX13g
Regards,
Lydia
Thank you Lydia.
My intention is not to have any manual intervention while loading the information. The data must be processed automatically.
The monthly information based on data refresh must be sought in the table and rest must be available for current live information.
Best,
KPKR
Currently, it is not possible to automate this process as you describe.
Regards,
Lydia