Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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 ?
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.
@Anonymous ,
Try like
conditional column =
var to_date = max('CalendarTable'[date])
return
if(
'DataTable'[date] <= to_date
,1
,0
)
Ive tried your solution.. it does not work .. variable still ignores date slicer filtering
(returned value should be 26.4.2021)
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |