DAX running total to limit data till selected date in the slicer

[Sabarikumar7579]

I am trying to control / limit the running total till the month i have selected on the Slicer.

For example : if i select in slicer FY month = 01-10-2018 the graph should show value till that particular month only.

The given data has value for the entire FY year.

My date is linked to a Date table too. So u can suggest considering this.

I tried using selectedValue([FY Month]) but i guess its move along the axis.

I am open for suggestion with "Edit with interaction" or "without edit interaction" between Slicer and the chart.

FY Month	Cost Forecast
01-09-2017	1
01-10-2017	2
01-11-2017	4
01-12-2017	7
01-01-2018	9
01-02-2018	11
01-03-2018	13
01-04-2018	15
01-05-2018	17
01-06-2018	19
01-07-2018	21
01-08-2018	23
01-09-2018	1
01-10-2018	2.5
01-11-2018	3.3
01-12-2018	5.5
01-01-2019	7.3
01-02-2019	10
01-03-2019	12.1
01-04-2019	15
01-05-2019	16
01-06-2019	17.3
01-07-2019	20.2
01-08-2019	22

Thank You

[v-frfei-msft · Accepted solution]

Hi @Sabarikumar7579,

1. Create a calculated table.

Slicer = DISTINCT(Table1[FY Month])

2. Create a measure as below.

Measure = var em = EOMONTH(SELECTEDVALUE(Slicer[FY Month]),0)
return 
IF(MAX(Table1[FY Month])<= em,1,0)

3. Create a table visual and filte it by the measure like this.

For more details, please check the pbix as attached.

Regards,

Frank

[MFelix]

Hi @Sabarikumar7579,

Why don't you use a slicer on your date and select the option of before that will give the information until that specific date.

Regards,

MFelix