Forum Discussion
date relation
Hello, I'm trying to make the relationship between my goals table and my calendar, but some mouths isn't showing, any help? Tryied other kind of relation, but didn't work as well
Anonymous , 1. Make sure date table has all the month
2. Check the date of the goals do not have a timestamp. Change data type to datetime (of date of goals ) and check does it has timestamp other than 00 hrs or 12 am. if yes create a date
date 1= datevalue(goal[date])
Check other rules
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.