Forum Discussion
Power BI formule Sumifs
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
Anonymous , A new column
sumx(filter(Table, [Date Column] = earlier( [Date Column] ) ), [Overdue Amount]) * [Overdue %]
1 Reply
Anonymous , A new column
sumx(filter(Table, [Date Column] = earlier( [Date Column] ) ), [Overdue Amount]) * [Overdue %]