Dynamic Category based on selected date

Hi all,

I'm trying to create a new category column to an existing table, but it needs to be calculated based on a date selected by the end user.

F.e. we have this simple table called Customer:

A new column needs to be added based on the logindate and a selected date. If the logindate <= selecteddate, then Yes else No.
(A calculated column is a possibility, but then the dataset needs to be refreshed every time)

I tried the following:

create a date table, not related to any other table, to be used as a slicer

create a new table based on the existing adding the logincategory:

LoginCat =

VAR OnDate = date(2020,1,16)

RETURN

CALCULATETABLE(

ADDCOLUMNS(CUSTOMER, "LoginCat", if(CUSTOMER[Logindate] <= OnDate, "Yes", "No"))

)

 This works fine with the date hard-coded:

But when I change the variable to = selectedvalue(calendar[date]) it doesn't pick up the selected date.

Any idea?

 

Thank you.

 

Vincent