Forum Discussion
Compare values with value from different row from different measure
Hello,
I have a problem with calculating a few things.
I have a simple table and need to compare two values. Index_Current with Index_New but the trick is to compare it with different value from different row.
Current_Index and Index_New are measures, but nothing sophisticated.
Example.
If Index_New is for example 6, then the measure should take WD_Sum value from the row where Index_Current is 6.
File to download below
https://we.tl/t-N9ZPZ5yGqX
Thank you
Anonymous see the attached solution, I hope that is what you are looking for, you can take it from here and tweak it as you see fit.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡
3 Replies
Anonymous see the attached solution, I hope that is what you are looking for, you can take it from here and tweak it as you see fit.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals 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.⚡
Like I wrote, everything looks fine but I don't quite undestand why comparing Current with new is the
Index_New = _indexCurrentBut the comparing new with current is
[Index_Current] = __indexNewI guess i had errors in the first place because I've thought that would be other way around. Can you explain more why does it work?
Best Regards