Mapping multiple date fields to Calendar Date Table

[Anonymous]

Hi Power users,

I have a dataset where I have many date fields. Please see below sample data.

Number	Branch	Credit_date	App_Date	Close_Date	Doc_Date
1000	MI	11/10/2018	1/12/2016	9/8/2017	9/20/2018
155	FL	6/8/2018	3/28/2016	10/14/2018	12/28/2016
637	CA	6/23/2018	1/2/2018	9/19/2017	8/17/2017
688	CA	1/23/2016	3/31/2018	8/29/2016	6/25/2017
736	CA	7/30/2018	12/20/2018	7/11/2017	3/2/2016
410	PA	11/30/2017	9/9/2017	8/21/2016	10/24/2018
323	CA	2/20/2017	11/6/2018	10/7/2017	4/4/2016
891	CA	5/10/2017	7/29/2017	1/11/2016	11/14/2016
394	CA	10/26/2018	3/19/2018	2/12/2017	9/4/2016

Now, I want a date slicer which works on all date fields. I am creating a calendar table and then creating relationship between calendar table and date fields of my dataset. But when I am selecting any Month and Year I am not seeing any data, I don't know how to fix it. Any help please?

My Calendar_table DAX Query: 

Calendar_Table = ADDCOLUMNS(
CALENDAR( DATE( 2015, 1, 1) , DATE(2020, 12, 31) ),
"Day", DAY([Date]),
"Month", MONTH([Date]),
"Year", YEAR([Date])
)

[v-juanli-msft]

Hi @Anonymous

I can't reproduce your problem about "when I am selecting any Month and Year I am not seeing any data".

Could you add your operation about this in my pbix?

Additionally, since there are many date columns in the data table which can have relationships with the calendar date table, but only one date column can have active relationship. the active relationship for my test is "Credit_date".

Best Regards

Maggie

[Anonymous]

Here's my mapping: