Previous week Matrix not showing up - week group

[VK_nz]

Hi all,

Hoping to get pointer in right dirction. 

I have sales file where I am counting weekly sales volume by 'week group', I also want to have second colum showing previous 'week group' number (in PW column weekgroup 08/07 should show 85). I have tried 'parallel period' function without success. 

Link to my file: https://www.dropbox.com/scl/fi/6h3kw0x8matq6c3ibxccz/Sales.pbix?rlkey=dxg1flzmszw4cw1c9meuhg28x&st=y... 

[Darui6]

Hi,

maybe you could a calculated column with the rank function for each week group (e.g week group 01/07 is ranked 1, then 08/07 2, then 15/07 3 and so on). https://learn.microsoft.com/de-de/dax/rank-function-dax

Then reference that rank in the calculation for the PW sales, where you use the measure for SalesVolume and say rank = rank-1.

[VK_nz]

It is giving incorrect no. to week index

[Darui6]

You're almost there.

Try it with the following formula:

WeekRank = RANK(DENSE, ORDERBY(Calender[Year], DESC, Calender[FinWeekNo], DESC))

[VK_nz]

this didnt go well, previously it was considring fiscal year and starting counter at July, reseting counter at next fiscal year.

This one just index at whole date range, so when a single fiscal year is selected this will result in inaccurate count.

Thanks for your answer though.