Forum Discussion
Merge Sumamry Table With Value Average
Team,
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
Table 1
Product Value
AAA 25
BBB 30
CCC 26
Table 2
Product Value
AAA 40
DDD 60
CCC 26
EEE 70
Table 3
AAA 60
CCC 30
unais value is a measure of what?
New Merge Table = UNION ( 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.⚡
1 Reply
- parry2kSuper User
unais value is a measure of what?
New Merge Table = UNION ( 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.⚡