Comulative total of data between the selected dates in Race Bar Chart

[ggzmorsh]

I need help with a similar problem on the link below.

https://community.powerbi.com/t5/Desktop/Cumulative-data-to-show-in-bar-chart-race/m-p/787057#M37906...

The solution was indeed correct just had to change it a bit

Running Total =
CALCULATE (
    SUM ( 'Table1'[Count] ),
    FILTER (
        ALLSELECTED ( 'Table1' ),
        'Table1'[Date] <= MAX ( 'Table1[Date] )
            && 'Table1'[Client] = MAX ( 'Table1'[Client] )
    )
)

the result was correct only if the selected date slicer is between 31 days. If the filter exceeded 31 days it would add august month and september month's day.

CalendarResult

[v-shex-msft]

HI @ggzmorsh ,

Do you mean add next/previous date period records(slicer selection date range) to current summarized data bar?

I think it is hard to achieve your requirement, you need to write measure formula with if statement to check current row contents and ignore calculation on 'uncompleted date period' and summarize them to previous data period.

Otherwise, these records will summarize based on current row contents group and filtered by current axis group.(year month)

Understanding DAX Auto-Exist

Row Context and Filter Context in DAX

Notice: if you are confused on coding formula, please share some sample data and expected result for test.

Regards,

Xiaoxin Sheng

[ggzmorsh]

Here is my pbix file. On the Project page contains the comulative data for the race bar chart.

If you select Aug1 to Aug31 on the date slicer it will give you the correct data. If you select Aug1 to Sep10 it will add Aug1-Aug10 and Sep1-Sep10 in the first 10 days of the bar chart.

https://drive.google.com/open?id=1fxtbvSZD-BzHnSjITCb3BnbGnGZ5KTmg