PowerBi DAX equivalent for SUMIFS in Excel for this case

[joaohenrique300]

Hello,

I want to make a measure or a new column in Power BI that can achieve the same result as the example below, to obtain the "RESULT" column. The expression in excel is =Sumifs(COL B;COL A;"<="&[@[A3]]).

[FreemanZ · Accepted solution]

hi @joaohenrique300 

try to add a calculated column like:

Column = 

SUMX(

   FILTER(

        TableName,

        TableName[Col A]=<EARLIER(TableName[Col A])

    ),

    TableName[Col B]

)