date_passed_to_condition_column_from_dateslicer

[Anonymous]

Hi,

Please i want to pass date from date slicer("type - before date") to conditional column.

I have 2 tables:

'DataTable'

'CalendarTable'

Slicer is configured to column 'CalendarTable'[date]

conditional column =

var [to_date] = calculate(  max('CalendarTable'[date]),  all('CalendarTable'[date])  )

return

if(

'DataTable'[date] <= [to_date]

,1

,0

)

I cannot pass the right date to [to_date] variable .. it ignores the date slicer value.

Thank you for any help.

[v-yingjl · Accepted solution]

Hi @Anonymous ,

First you should know that column would not affect by the slicer changed so if you want to do that, you need to create a measure instead of a column:

conditional measure =
VAR to_date =
    CALCULATE ( MAX ( 'Calendar Table'[Date] ), ALLSELECTED ( 'Calendar Table' ) )
RETURN
    IF ( MAX ( 'DataTable'[date] ) <= to_date, 1, 0 )

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yingjl · Accepted solution]

Hi @Anonymous ,

First you should know that column would not affect by the slicer changed so if you want to do that, you need to create a measure instead of a column:

conditional measure =
VAR to_date =
    CALCULATE ( MAX ( 'Calendar Table'[Date] ), ALLSELECTED ( 'Calendar Table' ) )
RETURN
    IF ( MAX ( 'DataTable'[date] ) <= to_date, 1, 0 )

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you ! this is awesome !

Now, if i want to filter dates by that conditional measure (filter with 2 states .. 1 and 0 .. selected value filters dates accordingly) .. is that possible ? 

Ive tried to create 2 columns that references that measure - doesnt work.

1,

conditional column = conditional measure

2,

conditional column = if(conditional measure = 1, 1, 0)

Would you create column for filtering ? .. or would you somehow use that measure ? .. or anything else ? 

[v-yingjl · Accepted solution]

Hi @Anonymous ,

If you want to filter the date by the slicer in the table visual, just put the previous measure in the table visual filter and set its value as 1:

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,

Try like

conditional column =

var to_date = max('CalendarTable'[date])

return

if(

'DataTable'[date] <= to_date

,1

,0

)

[Anonymous]

Ive tried your solution.. it does not work .. variable still ignores date slicer filtering

(returned value should be 26.4.2021)