In this video, we'll show you how you can create a calendar or date table using Power Query in order to display the time dimension in your report!
In Power BI, there are many so-called time-intelligence functions that let you make simple or complex calculations related to time. As the time dimension is present in practically every report, these types of functions are some of the most important in DAX. In order for these functions to be able to do their job, a calendar or date table is needed in the data model.
📝 To learn more & download PBIX example, please visit https://bit.ly/3rBNPQU
✅ Subscribe to always get our latest videos: https://www.youtube.com/ZebraBI?sub_c...
👉This playlist includes:
• How To Import & Set-Up Zebra BI Visuals From AppSource
• Power BI Income Statement or P&L In Just A Few Steps!
• How To Create Powerful Waterfall Charts In Power BI
• Loading Data From Data Sources To Power BI
• How To Create A Hierarchical Income Statement In Power BI
• Add A Custom Calculated Column To Your Power BI Report
• Sorting Correctly By Month Name In Power BI
• How To Set A Custom Sort Order In Power BI
• Power BI Unpivot (From Columns To Rows)
• Adding Your Own Columns For Custom Sort In Power BI
• How To Create A Calendar Table In Power BI Using Power Query
• How To Create A Calendar Table In Power BI Using DAX
• Exporting From Power BI To PDF & PowerPoint Slides
• Sorting Rows In Zebra BI Tables Visual
... and new video releases every week!
=========================================================
Get more practical tips & PBIX examples:
https://zebrabi.com/pbi-help/
=========================================================
#PowerBI #PowerBITutorial #ZebraBI
★STAY IN THE KNOW★
LinkedIn: / zebr. .
Twitter: / zebrabi
Facebook: / zebra.bi