Forum Discussion
Solved
Performing TOPN on filtered table
Hello! I am having a hard time finding the correct logic to use for an issue I have filtering a table. The table is a reference table with values that change over time (i.e. electricity rates tha...
MTBERRY1029 not sure if this is what you are looking for, see attached, tweak as you see fit.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡
parry2k
Super User
Super UserMTBERRY1029 what is the reference date? In the above example what would be the output?
For example :
REFERENCE_DATE = 4/10/21
OUTPUT: 0.13618
- Ashish_Mathur