Not fetching detail from Calander table even after proper relationship

[Anonymous]

Hi Experts,

I have crated a Calendar table as below:

Calendar = ADDCOLUMNS(CALENDAR(DATE(2019,1,1),DATE(2021,12,31)),"WeekDay",WEEKDAY([Date],2))

And create many-to-one relationship from Main table 'TransactionLog' (TransactionDate) to this calendar table (Date ).

When I am created calculated column as below with RELATED() function under main table:

TxDate_Week = RELATED('Calendar'[WeekDay])
OR

TxDate_CalendarDate = RELATED( 'Calendar'[Date])

Its actually not working.. both columns are fetching blank value. and there is no error at all.

Can you suggest/hint where i can check further?

[CNENFRNL]

Hi,  , did you verify if the format of 'TransactionLog'[TransactionDate] is Date instead of Text? All works well by my side,

[Anonymous · Accepted solution]

Hi @CNENFRNL , thanks for your response,

I got the resolution. It was giving error even when both columns were of datetime data type. One column from main table was having real time timestamp like '25/11/2020 18:30:00' and column from calendar table *created using DAX) was having fix timestamp for every date such as 25/11/2020 12:00:00 AM. hence it was not matching with each other.

Making both columns strictly 'Date' as datatype and format as 'd/m/yyyy' resolved the issue.

Thanks again for your response.