http://biinsight.com/quick-tips-time-dimension-with-time-bands-at-seconds-granularity-in-power-bi-and-ssas-tabular/
Quick Tips: Time Dimension with Time Bands at Seconds Granularity in Power BI and SSAS Tabular