Creating a MTD/QTD/YTD Time Intelligence Slicer in Power BI

Part one of four in a series. Learn how to leverage relationships and DAX calculated tables to create a time intelligence slicer in Power BI. The end result will perform faster and create a better user experience versus creating lots of unique time intelligence DAX measures.

RELATED CONTENT 🔗
Part 2: Applying USERELATIONSHIP Function --    • Applying the USERELATIONSHIP Function...  
Part 3: Additional Date Periods --    • Additional Date Period Filters for th...  
Part 4: Fiscal Periods --    • Fiscal Periods Time Intelligence Slic...  
Part 5: Avoiding Circular Dependencies --    • Improving the Time Intelligence Slice...  

BECOME A CHANNEL MEMBER 🎉
--    / @havensconsulting  

LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
--   / havensbi  
--   / reidhavens  
--    / havensconsulting  

VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:12 - Content Intro
1:08 - Demoing the Solution
2:43 - Showing the Model Design
3:29 - Showing the DAX Measures and Tables
5:45 - Discussing the DAX Code
8:17 - Summary Discussion

HAVENS CONSULTING PAGES 📄
Home Page - http://www.havensconsulting.net
Blog - http://www.havensconsulting.net/blog-...
Blog Files - http://www.havensconsulting.net/blog-...
Files & Templates - http://www.havensconsulting.net/files...
Consulting Services - http://www.havensconsulting.net/consu...
Contact & Support - http://www.havensconsulting.net/conta...

EMAIL US AT 📧
[email protected]

#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop