Forum Discussion

VK_nz's avatar
VK_nz
Icon for Helper I rankHelper I
2 years ago

Previous week Matrix not showing up - week group

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...
Need Help
VK_nz's avatar
VK_nz
Icon for Helper I rankHelper I
2 years ago

It is giving incorrect no. to week index

Darui6's avatar
Darui6
Frequent Visitor
2 years ago

You're almost there.

 

Try it with the following formula:

 

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

 

  • VK_nz's avatar
    VK_nz
    Icon for Helper I rankHelper I
    2 years ago

     

    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.