Forum Discussion

geoffw100's avatar
geoffw100
Copper Contributor
May 15, 2021

Calculate month to month movement in power query

Hello, this is my first post! I am working with a data file that provides sales data It is presented as client name, sales Y2D 2021 and sales for the same period 2020 The file is sent each mo...
excel
geoffw100's avatar
geoffw100
Copper Contributor
May 16, 2021
Thanks for the direction.

Could you expand on what you would do / I need to look for in power pivot?

Thanks
Yea_So's avatar
Yea_So
Bronze Contributor
May 16, 2021

Hi geoffw100 

 

Here's a video about Power Query, Power Pivot, and Calendar Tables rolled into one video that covers same period last year type of implementation.

https://youtu.be/e-CFYi52gpc

Resources