Lookup value of previous month in the same table in Power Query

[amikhan12345]

Hi,

https://community.powerbi.com/t5/Desktop/Lookup-for-the-value-of-previous-month-in-the-same-table/td...

Hope everyone is well. I am trying to achieve a solution similar to the above thread but using Power Query instead of DAX. I have appended multiple extracts of the same data in the same structure. Each extract has a timestamp column displaying the extraction date.

I want to create a custom column using Power Query which displays the same value but for the previous month. Example below:

Best regards,

Ami

[amikhan12345]

Thank you @amitchandak and thank you @ImkeF for the Power Query solution. The additional video on your website on was very helpful.

[ImkeF · Accepted solution]

Hi @amikhan12345 ,

you must group on "Customer" and return all values from your table. Then a apply a function that returns the previous row value like so: Fast and easy way to reference previous or next rows in Power Query or Power BI – The BIccountant 

If you need help applying this, please paste sample data that can easily used like described here:

https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

[amitchandak]

@ImkeF , Can you help on this.

@amikhan12345 , check with M experts . In Dax code can be

var _max = maxx(filter(Table,[customer] =earlier([customer) && [recorded timestamp] <earlier([recorded timestamp]) ),[recorded timestamp])
return
maxx(filter(Table,[customer] =earlier([customer) && [recorded timestamp] =_max ),[status])

[imranamikhan]

Hi @amitchandak 

I am trying to implement this formula as a DAX calculated column but the formula is not returning any fields for Customer. When you have a moment could you refine the syntax for me? (I appreciate you probably improvised this measure as an example)

Ami