Forum Discussion
help with volume based on multiple columns
Anonymous here is another approach where we split vendor and result in two different tables to avoid pivoting and then with the relationship we can achieve the result.
Anonymous see vendor 2 table, this is what I will do if no result column required.
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.⚡
Thanks parry2k , I do need all the other columns on that row: each vendor has their own time submitted, time completed, result and fee, and so I need those to all be inlcuded as well. It's quite hefty! I'm still loading too. 😕