Calculate total sum between date and today's date

[sherwood]

Likely an easy one for a Power BI Guru, but my calculation is not returning the correct result.

I have data like the below table, with Device Returned Date coming from a separate data source. 



The Cost Since Return column (that I'm trying to write a calculation for) is shown above as my desired result.

I'm trying to write a calculation that can give me totals like:

I'm not sure what I'm doing wrong but my calculation is showing incorrect figures between Service Cost and Cost Since Return, giving me bogus totals. 

Any help greatly appreciated. 

[Anonymous · Accepted solution]

Hi @sherwood ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) We can create a calculated column.

Cost Since Return = IF(EOMONTH([Billing Month],0)>EOMONTH([Device Returned Date],0)&&[Device Returned Date]<>BLANK(),[Service Cost],0)

(3) Then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[sherwood]

Many thanks, this works perfectly!