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)
The date table is marked as a date table
Use columns from the date table
The date does not have a timestamp
The date table has all dates
Other than these, bidirectional join with date table can also cause failure, because this can filter dates on date table and we might lose continuous dates.
I have discussed these in detail in my video on 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