I have a cumulative total not givinng proper result with year slicer

[Anonymous]

I have a DAX to calculate cumulative total.  it is giving correct result if there are no filters or slicers applied. I have year slicer, when I click on that, 2019 year gives me correct result for every month but when I click 2018, it is giving me same result for every month. I have only data from September to December for 2018. 

2019 result:2019 data

2018 Data

[Anonymous · Accepted solution]

I found solution for this. First of all I should be using Dates instead of months in the dat for x- axis. Also, to improve performance, it is better to create a Standard 'Date' lookup table. This helped to improve performace significanly. 

2018 cumulative count by Date