Power BI formule Sumifs

[Anonymous]

Hi Team,

I want to convert the formula =C3/SUMIFS(C:C,B:B,B3)*D3 in DAX to calculate Weighted Percentage.
Where Column C is Overdue Amount
            Column B is Date Column ie end of Each Month
            Column D is Overdue %
Please help

[amitchandak · Accepted solution]

@Anonymous , A new column

sumx(filter(Table, [Date Column] = earlier( [Date Column] ) ), [Overdue Amount]) * [Overdue %]