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

[xiumi_hou]

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:

[dm-p · Accepted solution]

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!