Forum Discussion
adityavighne
Continued Contributor
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.
mahoneypat
Microsoft Employee
Microsoft EmployeePlease 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