Filtering measure according to end date in Power BI?

[Analitika]

Hello,

I would like to ask how to make that measure calculation will respond only to this  changes?

My formula which doesn't work. How to resolve the issue?

[Anonymous · Accepted solution]

Hi @Analitika 

You can fix the start date of slicer without creating a measure.

Add the field [date] in Slicer and set the start date in visual filter. Make the value of date is on or after specified date. Then in options of slicer and choose Before , slicer will fix the start date you set in visual filter.

I have attached my pbix file , you can refer to it.

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Analitika ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

It should not respond to the start date ?

Do you need before or after, then you have those option in that small down arrow

[Analitika]

Yes should not respond to start date.

[amitchandak]

@Analitika , Then this should work

New Measure =
Var _max = maxx(allselected(Date) , Date[date])
return
calculate(sum(Table[value]), filter(all('Date'), Date[date] =_max))

or <=before , but prefer before slicer for that

New Measure =
Var _max = maxx(allselected(Date) , Date[date])
return
calculate(sum(Table[value]), filter(all('Date'), Date[date] <=_max))

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Analitika]

Still not works. Here is an error: