Forum Discussion
Date table relationships not working
LL_Yoor , Please change the data type of date to datetime and use format to show time and check there should not be any time other then 12 AM, if there is time other than 12 AM, then create a new date column and join on that
New Date = datevalue([Date])
Second date table may be missing dates which are there in date column of your tables.
please other reasons
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
LL_Yoor , Please change the data type of date to datetime and use format to show time and check there should not be any time other then 12 AM, if there is time other than 12 AM, then create a new date column and join on that
New Date = datevalue([Date])
Second date table may be missing dates which are there in date column of your tables.
please other reasons
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Thanks amitchandak - it was a timestamp issue. I had converted the data type of the date in my fact table to 'Date' but that wasn't working - had to follow your conversion tip in the video.