The article How to know if the Auto Date table is adequate when using Power BI provides a look into the inner workings of how Microsoft Power BI handles dates and times.

Learn to create custom security and threat dashboards for an overview of multiple data sources in Power BI with this guide.