Forum Discussion

sandee's avatar
sandee
Helper I
6 years ago

Calculate with Sum Function

Hi All,   I am trying to apply the formula to get "total Amt Due" for customer based on the "No of Days above then 0", but i am doing drag and drop it is not working, please can you guide where i a...
sandee's avatar
sandee
Helper I
5 years ago

answer is :

SUMX(FILTER('Raw Data','Raw Data'[Days overdue] >=0),'Raw Data'[Amt Due ])