Relationship calendar with simple facts table not showing date

[webportal]

Can someone please explain me why this relationship isn't working?

I have a calendar table with:

ADDCOLUMNS(
CALENDARAUTO(),
...
)

Which contains a date column related to "Document date" in Table1. Both columns are "Date" type (also tried with Date/Time).

I get the following table:

The first column is "Date" from the Calendar table. All other columns are from Table1.

Why is "Date" empty?

[synergised]

Looks like your "Document Date" is datetime in this example.  Most likely your date table is only date or a datetime with the time set to 00:00:00.  It is not matching because of the time component.

30-06-2019 00:00:00   vs   30-06-2019 23:59:59

Also, you might want to have a 1 to M relationship.

[webportal]

Hi @synergised 

Thanks for helping, but has mentioned before, I've tried with date also.

Have a look here:

https://drive.google.com/file/d/1MgPZqOyl5SesHA3KRXP6KMdDPaQIH3Mp/view?usp=sharing

[synergised]

Your relationship is using "Posting Date" instead of "Document Date"