Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
Hello experts!
I need help with RANKX.
I have a sales table :
Date | Emp | Group | Sales |
31-Dec-23 | Lana | Sales | 650,000 |
31-Dec-23 | Nick | Sales | 500,000 |
31-Dec-23 | Mary | Sales | 400,000 |
31-Dec-23 | Anna | Sales | 450,000 |
31-Dec-23 | Zaza | Ops | 30000 |
31-Dec-23 | Jiji | Eng | 30000 |
30-Nov-23 | Nick | Sales | 200,000 |
30-Nov-23 | Mary | Sales | 300,000 |
30-Nov-23 | Anna | Sales | 340,000 |
30-Nov-23 | Zaza | Ops | 300000 |
30-Nov-23 | Jiji | Eng | 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?
Solved! Go to Solution.
Hi,
PBI file attached.
Hope this helps.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
User | Count |
---|---|
141 | |
70 | |
69 | |
53 | |
52 |
User | Count |
---|---|
208 | |
94 | |
64 | |
60 | |
57 |