Forum Discussion
date_passed_to_condition_column_from_dateslicer
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.
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.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.
5 Replies
v-yingjlCommunity Support
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.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
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
Super User
Anonymous ,
Try like
conditional column =
var to_date = max('CalendarTable'[date])
return
if(
'DataTable'[date] <= to_date
,1
,0
)
