Forum Discussion
date_passed_to_condition_column_from_dateslicer
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.
Community SupportHi 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.