Forum Discussion
Date table not working
Hello Guys,
I created a date table, and have a one-many with a table which is a direct query, and i dont know why my date table is not working, my other table's joining column is also a date field with proper date data-type.
What can be the possible issue?
1. Mark date table as date table
2. Make sure date table has all dates
3. Your date in table might have timestamp (time other than 12:00 AM) and that is not visisble as you have used datatype date in DAX. Change that to datetime, use a format having time and check. If yes. have a column without date
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.
2 Replies
1. Mark date table as date table
2. Make sure date table has all dates
3. Your date in table might have timestamp (time other than 12:00 AM) and that is not visisble as you have used datatype date in DAX. Change that to datetime, use a format having time and check. If yes. have a column without date
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.Hello amitchandak
Is the issue happening due to the time constraint in the table, that my rows are not matching?
