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 ...
I cannot unpivot it, im using it in direct query
samratpbi
Super User
Super UserHi, if you cant use Power Query, then instead of the transformation, you can do sum of all the columns from Table 2 using DAX.
If this helps o resolve your problem, then please mark it as solution, Thanks!