Power BI: 5 Key Points to make Time Intelligence Successful

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

Amit has 18+ years of experience in Business Intelligence, Analytics, Data Science. He is Chief Analytics Officer at Kanerika & Power BI community Super User

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store