Forum Discussion
Summarize Values To One Column Without Aggregation
Hi, I have the following tables that I want to add from Table 1 the total summarized values From Table 2 Table1 - number of units bought each hour Table2 - number of items each buyer bought ...
Hi, In power query, for table 2, you need to select Buyer column and unpivot other columns. That will give you 3 columns, Buyer, Attribute (which is the items) and values.
Then you join the 2 tables based on Bauyer. Better to have Buyer dimension table and join based on Buyer name.
Also create a simple measure like Items value = SUM(T2[value]) (i.e. sum of the value column from the unpivoted table
Then in a table visual, bring Bauyer from the dimension table, all the columns from table 1, then the new measure which was created on table 2..
If this helps to resolve your problem, then please mark it as solumn provided, Thanks!