Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I have a filter pane in which I use the expression below to only allow the users to select a year once at a time.
=aggr(only([Year]), [Year])
Now my data set contains some future date, for instance, 2075 which I do not want to show up in the filter.
Is there any way, like set analysis, to allow me to adjust the filter without changing my data model?
I tried to add a set analysis within only(), but regarding the definition, it will only give me null().
Here is the screenshot of the filter pane:
Try this
=if(Year <= Year(Today()),Year)
I still want the user can only select one year at a time (single selection).
By adopting your suggestion, a single selection is not available.
Is there any way to combine the conditional expression with the single selection?
You may try: =aggr(only({< [Year] = {"<=$(=year(today()))"}>} [Year]), [Year])