Running total is continuing until end of year

[bishnu]

Hello,

I am tying to create running total for a status "open", though i managed to do it, its continuing till end of the year 2020  though i have datas untill may-2020. 

I used measure to count the monthly total (open) and using monthly total, i calculated the running total (another measure - "running total")

I am unbale to figure out why. Helps highly apppretiated

Thanks in advance

BB

[mahoneypat]

Please try this expression.  For me, the line chart ended where it should.  I called my table Status instead.

Running Total =
CALCULATE (
[Open Count],
FILTER ( ALLSELECTED ( 'Status' ), 'Status'[Date] <= MAX ( 'Status'[Date] ) )
)

Also, I encourage you to turn off Auto Date Hierarchy in your model, to simplify your DAX expressions.  The use of a separate Date table is also recommended for any model with date columns.

If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[bishnu]

Hello, 

Still it dosent work. it shows me data untill november 2020 wheras as i have data untill may 2020 (graph on the left which is just montly total terminates at may 2020.

I didnt quite understand why i should remove data Hierarchy

Many thanks

BB

[v-eachen-msft]

Hi @bishnu ,

You could create a measure to judge the sum of "open" for each year. 

Measure =
IF([Open]>0,1,0)

Then add it in the filter pane to show result = 1.

[bishnu]

Hello,

I tried but it dosent work

Regards

BB

[camargos88]

Hi @bishnu ,

Try creating a dim table till the end of 2020 and use this field for running total and charts.

[bishnu]

Hello, 

But i dont have data till end of the yeaar. Just have data till may

Thanks

BB