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
Go to 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.
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
View solution in original post
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.
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
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.