DAX for Power BI Part 7.3 - Single Calendar vs Multiple Calendars скачать в хорошем качестве

DAX for Power BI Part 7.3 - Single Calendar vs Multiple Calendars

By Andrew Gould Download files here https://www.wiseowl.co.uk/power-bi/vi... If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:    / @wiseowltutorials   Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! In this video you'll see a couple of techniques for creating calendars to handle multiple date fields in the same data model. You'll learn how to use the Calendar function to create multiple calendars spanning sensible date ranges which is useful when your different date fields hold very different date ranges. You'll also learn how to use the CalendarAuto function which is useful when you want a single calendar to handle all the date fields in the model. If you're using a single calendar you'll also need to know how to create and manipulate multiple relationships to the same table, and how to use the UseRelationship function in measures to ensure that you're calculating the correct values! Chapters 00:00 Topic list 00:52 The Data Model 02:14 Checking the Range of Dates 03:59 Calculating a Calendar 05:56 Adding Columns to the Calendar 07:24 Connecting the Calendar in the Data Model 09:27 Creating a Second Calendar Table 11:54 An Example with Overlapping Dates 14:25 Using the CalendarAuto Function 16:17 Creating Multiple Relationships 18:21 Deactivating all Calendar Relationships 19:14 The UseRelationship Function 21:26 Measures Using Different Relationships 22:29 Adding More Filters in the Calculate Function Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!