Add TOTAL column within table

Hi I have a table and would like to add a total column as a column in between the values. All values needs to be summarized except colum with value 2220. See screenshot below. All values from ...

tamerj1

3 years ago

mnb_dk
please follow the power query transformation details in the sample file.

Total Amount = 
SUMX ( 
    VALUES ( G_L_Amount_Numbers[Account] ),
    IF ( 
        G_L_Amount_Numbers[Account] = "Total",
        CALCULATE ( 
            SUM ( 'Table'[Amount] ), 
            G_L_Amount_Numbers[Account] <> "2220", 
            ALL ( G_L_Amount_Numbers[Index] ) 
        ),
        SUM ( 'Table'[Amount] )
    )
)

Community 675.pbix33 KB

Forum Discussion

Add TOTAL column within table

Related content

Total Count in Column

Total value missing in calculated column

Cumulative Total

COLUMN TOTAL AS FIRST COLUMN OF THE MATRIX VISUAL

Total Value Column Measure