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
Yea_So's avatar
Yea_So
Bronze Contributor
May 16, 2021

Hi geoffw100 

 

Look into Power Pivot especially in the area of Data Modeling.  Therein your will find your treasure trove of answers.

  • 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