Forum Discussion

BalaKrish's avatar
BalaKrish
Helper I
4 years ago

Getting the sales value 3 months ago by using Power Query

Dear All,

 

I have two columns in my table , 

 

1. Sales

2. Date

 

I need to create a new column " Sales 3 months ago" in PowerQuery (Not a DAX column). Can someone suggest an idea to create it?

 

Thanks in advance!

Interesting Links
Need Help
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    BalaKrish , You can have new date which three month ahead, so when sum in visual you will three month behind sales.

     

    New Date =  Date.AddMonth([Date], 3)

     

    or you can group data now by new date