Carlo1975Helper I5 years agoSolvedMatrix table with sum Hi, I have a problem and I don't know how to overcome it. I don't know if the solution is Dax or power query. I'm sorry. I try to explain. I have a table like this. With 2 clusters columns, one ...Show MoreCNENFRNL5 years agoHi, Carlo1975 , you might want to use this measure,Accum = VAR __qtr = MAX ( Table1[Quarter] ) RETURN CALCULATE ( SUM ( Table1[Amount] ), Table1[Quarter] <= __qtr )
CNENFRNL5 years agoHi, Carlo1975 , you might want to use this measure,Accum = VAR __qtr = MAX ( Table1[Quarter] ) RETURN CALCULATE ( SUM ( Table1[Amount] ), Table1[Quarter] <= __qtr )
CNENFRNL5 years agoHi, Carlo1975 , you might want to use this measure,Accum = VAR __qtr = MAX ( Table1[Quarter] ) RETURN CALCULATE ( SUM ( Table1[Amount] ), Table1[Quarter] <= __qtr )
CNENFRNLCommunity Champion5 years agoHi, Carlo1975 , you might want to use this measure,Accum = VAR __qtr = MAX ( Table1[Quarter] ) RETURN CALCULATE ( SUM ( Table1[Amount] ), Table1[Quarter] <= __qtr )
Related contentMatrix tableMatrix tableKPI level matrix tableMatrix table in Power biPowerBI - Matrix table, hide values used only for a visual calculation
