Filter date with independent slicer

[patoku0207]

hello

I'm new to Power BI. I have a date slicer with a first date and a second date.

This slicer is not related with the principal table who needs to be filtered.

I made a column " Filtre_cax_1" with this mesure :

Filtre_Cas_1 =

var MinDate = FIRSTDATE(Calendrier_SIF[DateSQL])   ' 01/09/2023 in this example

var MaxDate = LASTDATE(Calendrier_SIF[DateSQL])   ' 30/09/2023 in this example

RETURN

IF(LASTDATE(PassageStock[DateSortie])<MinDate,1,0)

I would have 1 if DateSortie < 01/09/2023 and 0 if not.

As you can see it doesnt work with NumeroLot 0001027669( DateSortie is higher than MinDate so Filtre_Cas_1 should be 0.

Thanks for your help and sorry for my poor english .

Patrice

[parry2k]

@patoku0207 use MAX or MIN instead of SELECTEDVALUE

[patoku0207]

hello and thanks for your answer. Unfortunately SELECTEDVALUE is not recognized .

I use a direct connection to analysis services and dont import datas.

[parry2k · Accepted solution]

@patoku0207 try this:

Filtre_Cas_1 =
var MinDate = FIRSTDATE(Calendrier_SIF[DateSQL])   ' 01/09/2023 in this example
var MaxDate = LASTDATE(Calendrier_SIF[DateSQL])   ' 30/09/2023 in this example
 
RETURN
IF(SELECTEDVALUE(PassageStock[DateSortie])<MinDate,1,0)