In this video, we'll show you how to create a calendar or date table using the #DAX function to display the time dimension in your report!
Many so-called time-intelligence functions in #PowerBI let you make simple or complex time-related calculations. As the time dimension is present in practically every report, these functions are some of the most important in DAX. For these functions to be able to do their job, a calendar or date table is needed in the data model.
Timestamps:
00:00:00 Intro
00:00:20 Data model overview
00:01:06 How to add the date table
00:02:40 How to add additional columns
00:05:20 Create reusable code
To learn more or to get additional help with your Zebra BI for Power BI visuals, please visit bit.ly/3RCtK7E
✅ Subscribe to always get our latest videos: www.youtube.co...
👉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:
bit.ly/3RCtK7E
=========================================================
#PowerBI #PowerBITutorial #ZebraBI
★STAY IN THE KNOW★
LinkedIn: / zebr. .
Twitter: / zebrabi
Facebook: / zebra.bi
17 авг 2024