Please advise We have how can we merge Three Summerize Table with Value Column Average
below table Scenario and Need to create New Table With Product and Average Value
Go to Solution.
@unais value is a measure of what?
New Merge Table =
SUMMARIZE ( TableA, TableA[Product], "Value", [Value] ),
SUMMARIZE ( TableB, TableB[Product], "Value", [Value] ),
SUMMARIZE ( TableC, TableC[Product], "Value", [Value] )
assuming value is a measure
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021