cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
xiumi_hou Post Patron
Post Patron

Need Help(Very urgent!!!!!!) with link two tables by date

I was trying to add relationship of two tables. 

 

1. d_date[date] with unique date value I create from 2012 to 2019 April

2. f_calls[call_date] with a list of all the calls date 

The realtionship to these two tables are one to many.

 

And I use a function to calculate all the calls made in a specific date range. The function are as below: 

Calls Count A1 Assessment Held =
CALCULATE(
COUNT(f_calls[Parent_id]),
FILTER(
f_calls,
f_calls[Status]="Held" &&
f_calls[Type_c]= "Assessment"
)
)
When I use the filter and value as f_calls[date], which looks good. However, when I use d_date[date] as silcer filter, it gave empty result (all equal to 13) unless I choose the entire date range(result 8211).
 
Any idea about this stitution? Thanks!
 
As of below: 1.JPG2.JPG


1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: Need Help(Very urgent!!!!!!) with link two tables by date

Hi there,

You're going to be better asking this question in the Desktop forum, as there's a lot of data modelling/DAX experts in there that typically don't frequent the Developer forum.

The first thing I personally check with a related column using dates, is the data type on each side of the join. Start with Power Query - both columns should be of type Date in the final step. Often, one of my table's columns is Text or Date/Time (particularly if it's been part of a transformation on the way through) whereas the other is Date, and this means the join may not always resolve.

If your types are okay, I'd suggest re-posting your question in the Desktop forum, or asking a moderator to move this one across.

Good luck!





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

Proud to be a Super User!




View solution in original post

1 REPLY 1
Super User I
Super User I

Re: Need Help(Very urgent!!!!!!) with link two tables by date

Hi there,

You're going to be better asking this question in the Desktop forum, as there's a lot of data modelling/DAX experts in there that typically don't frequent the Developer forum.

The first thing I personally check with a related column using dates, is the data type on each side of the join. Start with Power Query - both columns should be of type Date in the final step. Often, one of my table's columns is Text or Date/Time (particularly if it's been part of a transformation on the way through) whereas the other is Date, and this means the join may not always resolve.

If your types are okay, I'd suggest re-posting your question in the Desktop forum, or asking a moderator to move this one across.

Good luck!





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

Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors