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 solution attached, with this transformation you can achieve and filter on anything, I gave few visuals on how you can have a scalable solution. It all boils down to the data model and how to optimize your tables.
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.⚡
Ahhh, unpivot! Thank you, I had absolutely forgotten about that!! I am testing it now to see if it works for me as well as it seems like it will; however, it's been applying my query changes for over an hour now so I am a little concerned. If it goes through, I will come and mark yours as a solution. Thank you!