topic PowerBi DAX equivalent for SUMIFS in Excel for this case in DAX Commands and Tips

PowerBi DAX equivalent for SUMIFS in Excel for this case

joaohenrique300 — Sat, 18 Feb 2023 03:26:11 GMT

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]]).

Re: PowerBi DAX equivalent for SUMIFS in Excel for this case

FreemanZ — Sat, 18 Feb 2023 04:01:27 GMT

hi joaohenrique300

try to add a calculated column like:

Column =

SUMX(

FILTER(

TableName,

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

TableName[Col B]

)