Forum Discussion
Filtering data with dates from multiple tables using a single date slicer
Hi ryan_mayu
I am attaching the table visual, I want to filter the Call Attempt Date 1, Call Attempt Date 2, Call Attempt Date 3 from one table, Actual End from another table when these dates fall under the date selected in the date slicer. All were date time fields.
I tried to use something like this with one date for ex: IsDateInBetween =
VAR CheckMinDate = DATE(YEAR(MIN('Date'[Date])), MONTH(MIN('Date'[Date])), DAY(MIN('Date'[Date])))
VAR CheckMaxDate = DATE(YEAR(MAX('Date'[Date])), MONTH(MAX('Date'[Date])), DAY(MAX('Date'[Date])))
RETURN
IF (
('shs_followupcalllog'[shs_calldate]) > CheckDate && 'shs_followupcalllog'[shs_calldate]) <= CheckDate ,
1,
0
), but it dont give me correct result.
Could you please suggest on this.
Thank you.
Cheers,
PMDY