How to find Nth number for every Category every last 8 weeks ? or nth Percentile of last 8 weeks

[Bhima_Merad]

Hi Team,

I am trying to achieve following output where user need the nth percentile of last 8 weeks.

Exa- We need to find out 5th Lowest value in running last 8 weeks for each product

here for Prd 1 we have last 8 weeks sales .

69

1

196

90

119

8

169

47

If we arrange them in asc order 5th value is the output

1st set 8 Weeks

1

8

47

69

90

119

169

196

likewise for other weeks set.

please let me know if there is any way we can achieve this?

[amitchandak · Accepted solution]

@Bhima_Merad , Try the index function with Partitioned by week

Power BI Quick Look at newly released Dax Function Offset, Window, Index: https://youtu.be/KhkCALjHylE

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8