Forum Discussion

naveen73's avatar
naveen73
Copper Contributor
Aug 24, 2024

Power Pivot running total without date column - NOT in Power BI

Hi all, I am using Power Pivot in Excel and want to calculate the running total without Date column. I found the following tutorial, which is for DAX in Power BI and tried to convert this to Excel ...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Sep 02, 2024

Hi naveen73 

 

 

Measure [Run_Total]:

=
VAR CurrentBrandSales =
    MIN ( Products[Total Sales] )
VAR BrandsWithSales =
    ADDCOLUMNS ( ALLSELECTED ( Products ), "@Sales", Products[Total Sales] )
VAR BrandsWithHigherSales =
    FILTER ( BrandsWithSales, [@Sales] >= CurrentBrandSales )
RETURN
    SUMX ( BrandsWithHigherSales, [@Sales] )

 

Resources