RELATED not returning column values from related table

[Hiranyaksh]

Hello Community,

I have created a Calendar Table, add a column for Holidays from RELATED Holiday table. 

I am not able to add columns from any related table into the Calendar table, it returns only blank values from related tables.

The relationship is based on Date columns of Calendar and related Tables AND RELATIONSHIP type is 1:1

I will appreciate if anyone can solve this problem