Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
pavanmanideep
Helper III
Helper III

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

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

2 REPLIES 2
pavanmanideep
Helper III
Helper III

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.

 

pavanmanideep_0-1718949775360.png

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

ryan_mayu
Super User
Super User

could you pls provide some sample data and expected output?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

Check out the May 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.