Calculating cumulative sum by date, but remove blanks

[Anonymous]

Hi All,

Real NOOB here with Power Bi, but I have imported data from Excel, and it contains a date column for "Expense_Planned" and a colum for "Amount".  (Obviously there is other datea, but these are my main focus for now) I am using the following calculation to get to cumulative sum by date:

Planned Sum = (

CALCULATE(

    sum('Table'[Amount] ),

    FILTER(ALL('Table'),'Table'[Expense_Planned]<=max('Table'[Expensed_Planned])))

)

It appears to work with the exception that there are rows where the Expense_Planned is blank ('null').  I want ot exclude them from the calculation.  The calculation works as expected, but is off by the exact amount in the rows with this blank cell.  I figured using a Filter would work, but if I omit "blank" with the filter, all that does is not show the row in the table. 

Thanks!

[Anonymous]

I created a small example:

Sample File 

[sayaliredij]

Hi @Anonymous 

Could you share sample pbix file with expected output? You can remove all sensitive and irrelevant data 

Its quite difficult to understand what in which table the blank row should show when you apply blank filter

Thanks,

Sayali