Forum Discussion
Continued ContributorDate relationship not showing data
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
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
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.
4 Replies
Tahreem24Super User
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
Microsoft Employee
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
- ilton
Helper I
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
