Date relationship not showing data

[adityavighne]

Hi,

I have relationship between calendat date and another table created on date. but output is showing blank data.

date range - 1 jan 2020 - till date

format of date - mm/dd/yyyy

[mahoneypat · Accepted solution]

Please make sure both columns are type Date in the query editor (one might be DateTime).

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[teamanalytics]

I have the same issue. My source date from sql is date time (direct query so I cant change it) however I changed it in the calendar to date time but it pulls the data to a specific date and after that its blank

[ilton]

Hi! @adityavighne 

Make sure the related column are in the same format and make sure the relationship cross filter direction is single, otherwise any filter applied to the 3 2020 table will affect the calendar table

[Tahreem24 · Accepted solution]

@adityavighne ,

First make sure that both these Date columns are in same format.

And, try to take both these Date columns in Same Table visual and see what will you get.

[mahoneypat · Accepted solution]

Please make sure both columns are type Date in the query editor (one might be DateTime).

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat