Limit date with button

[Haeser]

Hello, good morning!

I would like to limit the date from my data, based on a selected button.

Right now, i have 4 measures, ID from selected button, first data date, todays date, and last updated data. On the screen, i have a button (ChicletSlicer), where it says "today" or "last update", that are affiliated to an ID.

I tried several ways to filter the data, but without success (including datesbetween, filter, etc). What would be the correct way to accomplish this?

Thanks in advance! 

[PijushRoy]

Hi @Haeser 

Requirement is not clear to me, can you please share pbix and expected result.

[Haeser]

Hi @PijushRoy , thanks for the quick response!

Unfortunately, I can't share the pbix, but the expected result would be that when selecting "Hoy" in the upper Chiclet, data would be filtered up to today's date. And when "Ultima Carga" was selected, the last date would be different, according to the "DataFiltrada" measure, as shown in the image.

My difficulty is in the measure syntax to use this limit, for example, i tried: measure = FILTER(myTable, myTable[date], DATESBETWEEN(firstDate, lastDateSelected)) , to limit my last date on all tabs, but it was not successful.

[v-xiaotang]

Hi @Haeser 

Not having a sample file to test, so I am not very sure. Maybe you could try the measure below to check the period,

measure= 
  var _timeMin= calculate(min(myTable[date]),FILTER(myTable, myTable[date], DATESBETWEEN(firstDate, lastDateSelected)) )
  var _timeMax= calculate(max(myTable[date]),FILTER(myTable, myTable[date], DATESBETWEEN(firstDate, lastDateSelected)) )
return _timeMin & unchar(10) & _timeMax

Best Regards,

Community Support Team _Tang

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