Forum Discussion
Solved
Using selected date in slicer to filter dates in another table
I have two separate tables: 1. "From" date 2. "To" date Both tables have identical list of dates but I would like to use both as them as separate slicers. For Example, I have dates from 1/1...
Hi bcng,
Based on my test, you could refer to below steps:
Create a measure:
Measure = IF(CALCULATE(MAX('To'[Date]))>=SELECTEDVALUE('From'[Date]),1,0)Set the visual slicer:
Result:
But the measure could not be applied it in the slicer, I suggest you use the measure in visual.
Regards,
Daniel He
Hi Greg,
I tried using this measure:
Measure = IF('To Date'[Current Historical]>=VALUES('From Date'[Current Historical]),'To Date'[Current Historical],BLANK())
but I am getting this error:
A single value for column 'Current Historical' in table 'To Date' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.
Can't seem to figure out how to work around this error.
I have already created a relationship between the two columns
v-danhe-msft
Microsoft Employee
Microsoft EmployeeHi bcng,
Based on my test, you could refer to below steps:
Create a measure:
Measure = IF(CALCULATE(MAX('To'[Date]))>=SELECTEDVALUE('From'[Date]),1,0)
Set the visual slicer:
Result:
But the measure could not be applied it in the slicer, I suggest you use the measure in visual.
Regards,
Daniel He