Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
102 | |
98 | |
89 | |
70 |
User | Count |
---|---|
166 | |
131 | |
129 | |
102 | |
98 |