Refer Previous Row for Subgroup in Power Query

[@GoodlyChandeep]

Download Data - www.goodly.co.in/wp-content/uploads/2021/08/Data.xlsx Post your answers here - www.goodly.co.in/refer-preview-row-subgroup-power-query/

[@govardhanbola1195]

I have a situation like this, for calculating MoM and WoW, I need to consider same period in the previous year. Let's say if I want to return MoM for August 2021, then calculation would be like (Aug_2021 sales - Aug_2020 sales)/Aug_2020 sales * 100. Like this it should be dynamic for MoM and WoW and in the view I need to display like Last 12 months for MoM % growth, and Last 13 months for WoW % growth. I achieved the calculation but not able to restrict last 12 months/13 weeks. Any help on this would be helpful. Note: we are not supposed to use calendar table as per our requirement. So considering sales_date from data itself and I achieved WoW and MoM based on month_number and Week_Number. And based on maximum sales_date, we need to display last 12 months or Last 13 weeks.

[@arbazahmad7177]

Great 👍

[@wayneedmondson1065]

Hi Chandeep. Awesome challenge! Just posted a few solutions. Learned a lot in the process :)) Thanks and Thumbs up!!

[@premmbissht9140]

Hay, Chandeep just wanna know when you would be starting you online live class room sessions in sep month.

[@GoodlyChandeep]

The next live class is going to be in Nov / Dec

[@amoljagdale5626]

I need help in below scenario- Suppose category A has opening n closing count and opening is the last week of closing count and closing would be opening-fulfil count..I tried as per ur video but facing circular dependency error.this is the next level..Could u plz help

[@akhilgupta513]

1) Source= Excel.Workbook(File.Contents("C:\Users\aklnu\Downloads\Data.xlsx"), null, true) 2)Navigation= Source{[Item="Data",Kind="Table"]}[Data] 3)Added Index= Table.AddIndexColumn(Data_Table, "Index", 0, 1, Int64.Type) 4)Added Custom= Table.AddColumn(#"Added Index", "Custom", each try if ([Category]=#"Added Index"{[Index]-1}[Category]) then #"Added Index"{[Index]-1}[Value] else null otherwise null