Forum Discussion
RANKX with filter
- 5 years ago
ConnieMaldonado enjoyed doing this. check attached. I hope this is what you are looking for?
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
ConnieMaldonado sorry for the delay on this, I think I'm almost done but need to understand bit:
on the final output page, the first row, how come you have total of hours 91 for this loc1, id and date
where if you look at raw data (first page in excel ) the total hours are 139.06 (Highlighted in yellow) for the same date:
Am I missing something or it is something else?
Let me check it! Hold on.