Forum Discussion

Burcu's avatar
Burcu
New Member
8 years ago

Running total with If condition

Hi all, I'm new in power BI and I'm trying to change excel reports to Power BI. I have a table in excel like this Date Daily Total USD USD RunnigTotal 31.12.2017 0,00 0,00 1.01.2018 ...
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Burcu

 

Try this calculated column

 

Calculated Column =
CALCULATE (
    SUM ( COMBINE[Daily Total USD] ),
    FILTER ( COMBINE, COMBINE[Date] <= EARLIER ( COMBINE[Date] ) )
)
Burcu's avatar
Burcu
New Member
8 years ago

Hi Zubair_Muhammad,

Thank you for your reply. It almost solved my problem. There is a little problem when the running total turn negative.

when calculation result turns the negative it would continue and start to get total on your own row. Do you have suggestions for that?

PS. I want to reach the same result with USD Calculated in Excel column.