Forum Discussion

Haeser's avatar
Haeser
Frequent Visitor
4 years ago

Limit date with button

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! 

Need Help

3 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    4 years ago

    Hi Haeser 

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

    • Haeser's avatar
      Haeser
      Frequent Visitor
      4 years ago

      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's avatar
        v-xiaotang
        Community Support
        4 years ago

        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.