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 Mon...
Anonymous , A new column
sumx(filter(Table, [Date Column] = earlier( [Date Column] ) ), [Overdue Amount]) * [Overdue %]
amitchandak
Super User
Super UserAnonymous , A new column
sumx(filter(Table, [Date Column] = earlier( [Date Column] ) ), [Overdue Amount]) * [Overdue %]