Monthly snapshot capturing

[kpraveen1397]

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 time and efforts.

Best,

K.Praveen Kumar Reddy

[v-yuezhe-msft]

@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...
https://www.youtube.com/watch?v=xDVUUcbX13g

Regards,
Lydia

[kpraveen1397]

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

[v-yuezhe-msft]

@kpraveen1397,

Currently, it is not possible to automate this process as you describe.

Regards,
Lydia