cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JS Regular Visitor
Regular Visitor

Empty Date question

Hi guys,

 

I understand the usage of a date diemension table, but I have error connecting the date in the date table with my date in my other table (table A). 

 

As I have empty dates field in table A, I am unable to link up the relatiobship between the date table and Table A. Is there an alternative work around to this?

 

Thanks,

JS

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-qiuyu-msft
Moderator

Re: Empty Date question

Hi @JS,

 

According to your description, table A contains a date field and there are some empty values in this field. When you built the relationship between the date table and Table A, the error occurs, right?

 

In your scenario, which error did you get when you built the relationship? Please make sure date field in table A is date data type. The table A date column empty values will not affect relationship between date table and table A, see:

 

w1.PNGw2.PNG

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

Re: Empty Date question

Hi @JS,

 

According to your description, table A contains a date field and there are some empty values in this field. When you built the relationship between the date table and Table A, the error occurs, right?

 

In your scenario, which error did you get when you built the relationship? Please make sure date field in table A is date data type. The table A date column empty values will not affect relationship between date table and table A, see:

 

w1.PNGw2.PNG

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
suryaprakashred Frequent Visitor
Frequent Visitor

Re: Empty Date question

Hi @JS,

 

            There wont be any problem in connecting the date dimension table and table1 even if there are missing values in table1.I think the problem might be you are trying to connect the id in data dimension table to the date value in table 1 which will obviously give the error as it cannot connect the id in one table to date value in other table(as it is not a common field).Check it once,everything will be fine.If u can,post the image of your model once.

 

           note-if this solves your problem,please click this as accept the solution

 

thanks and regards,

k.surya.