display dates in a filter.

[Syndicate_Admin]

Good, I want to show the filters that I have selected and they work all except the date.

Since I can show the selected date, all the data is in the same table. I give you the example.

[amitchandak]

@Syndicate_Admin , Not very clear

new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return

"From " & _min & " to " & _max

Measure = concatenatex(allselected(Date), Date[Date], " , " )

[Syndicate_Admin]

Hello and first of all thank you.

I have achieved something, but not as you tell me, since it gives me an error, the problem I have with the allselect, I put my measurement that works, but that is not complete and I tell you, in case you can indicate the failure, as I tell you, I do not have a calendar table, but a column in the table that contains all the data.

This works but is incomplete:

e_Fechas =

WHERE _max = MAXX(F_BI_EXPEDIENTES_USUARIO, F_BI_EXPEDIENTES_USUARIO[FECHA_APERTURA])

WHERE _min = MINX(F_BI_EXPEDIENTES_USUARIO, F_BI_EXPEDIENTES_USUARIO[FECHA_APERTURA])

return "Del "&_min &" to"& _max

I think I have the problem in the maxx and in the minx

Greetings

[MFelix · Accepted solution]

Hi @Aguirre ,

In the expression you are using the problem is that you did not close the ALLSELECTED expression try the following:

e_Fechas2 =
VAR _max =
    MAXX (
        ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
        BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
    )
VAR _mIN =
    MAXX (
        ALLSELECTED ( BI_EXPEDIENTES_USUARIO ),
        BI_EXPEDIENTES_USUARIO[FECHA_APERTURA]
    )
RETURN
    _Max & _Min

[Syndicate_Admin]

thanks to @Syndicate_Admin

It has worked for me in this way, just comment that the 2nd variable is with MINX since it appears twice MAXX.

Greetings.

[MFelix]

Hi @Aguirre ,

Sorry for the error I just wrote the first part of the variable and paste it a second time did not change it but you are correct.