Forum Discussion

elior's avatar
elior
Regular Visitor
2 years ago

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   ...
Need Help
elior's avatar
elior
Regular Visitor
2 years ago

maybe dax will be ok, by which formula ?

samratpbi's avatar
samratpbi
Super User
2 years ago

sum of all the columns from table 2, i.e. SUM(T2[7]) + SUM(T2[8])...... so on. where I assume 7,8... are the column names in 2nd table T2

  • elior's avatar
    elior
    Regular Visitor
    2 years ago

    the table is dynamic query.

    i tried it, but with the same result - aggregation by hour.