topic Re: Filtering data with dates from multiple tables using a single date slicer in DAX Commands and Tips

Filtering data with dates from multiple tables using a single date slicer

pavanmanideep — Thu, 20 Jun 2024 09:35:34 GMT

Hi Experts,

I am facing an issue, here is the brief description of the issue I am facing

I have a date table D1 created from calendar function. I have a date slicer pointing to this date table. I have two custom tables C1 and C2 with 3 call log date fields from C1 itself and one actual end date in C2. I want to show the data from both custom tables in table visual when any of dates either in C1 or C2 fall under the date selected in the date slicer.

I tried to get the start and end dates of the date slicer, and calculate the difference between the dates from slicer with the dates from C1 or C2 custom table, but it dont seem to work and differences show wrongly. Please note that I dont have relationship with my custom tables and date table.

I am checking from past 2 days without any clue. Appreciate if any one can assist in this, do let me know if you require any addional details.

Cheers,

PMDY

Re: Filtering data with dates from multiple tables using a single date slicer

ryan_mayu — Thu, 20 Jun 2024 09:42:53 GMT

could you pls provide some sample data and expected output?

Re: Filtering data with dates from multiple tables using a single date slicer

pavanmanideep — Fri, 21 Jun 2024 06:13:14 GMT

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