Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Nick_Kalichava
Frequent Visitor

RANKX with condition

Hello experts!

I need help with RANKX.
I have a sales table : 

DateEmpGroupSales
31-Dec-23LanaSales650,000
31-Dec-23NickSales500,000
31-Dec-23MarySales400,000
31-Dec-23AnnaSales450,000
31-Dec-23ZazaOps30000
31-Dec-23JijiEng30000
30-Nov-23NickSales200,000
30-Nov-23MarySales300,000
30-Nov-23AnnaSales340,000
30-Nov-23ZazaOps300000
30-Nov-23JijiEng

300000

 

I need to rank employees only form Group = "Sales" and only the ones that workd previous month... O.O

So the outcome for december ranking would be 

Nick 1

Anna 2

Mary 3.

 

Any suggestions?

 

3 ACCEPTED SOLUTIONS
Ashish_Mathur
Super User
Super User

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1705196668888.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

Ahmedx
Super User
Super User

here's another solution

Screenshot_4.png

View solution in original post

ThxAlot
Super User
Super User

ThxAlot_0-1705211627936.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



View solution in original post

3 REPLIES 3
ThxAlot
Super User
Super User

ThxAlot_0-1705211627936.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



Ahmedx
Super User
Super User

here's another solution

Screenshot_4.png

Ashish_Mathur
Super User
Super User

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1705196668888.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.