Why Time Intelligence Fails
Power BI provides a very strong time intelligence, with a great list of functions around. But still, Time Intelligence fails. This is because the setup is not correct.
Five key points to remember
Use Date Table (Join with Fact Date)
Date table is marked as a date table
Use columns from date table
Date does not have a timestamp
Date table has all dates
I have discussed these in details in my Video at YouTube
Please let me know your comments.
This link will take you to the power bi dashboard that has links for all my blogs and videos — You can get all my posts at https://community.powerbi.com/t5/Data-Stories-Gallery/Blog-Analysis/m-p/1265567#M4403 Like, Share, comment, Give suggestions for improvement, and next post/video.
You Can watch my Power BI Tutorial Series on My Channel, Subscribe, Like and share