DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions
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!
This video shows you how to apply filters in your DAX measures using the Calculate, Filter and CalculateTable functions. You'll learn how to apply single and multiple filters, how to use the And, Or and In operators and how to work with numbers, text and dates. You'll also see the limitations of filter arguments in the Calculate and CalculateTable functions and how to nest the Filter function to get around these limitations.
Chapters
00:00 Topic list
00:46 Getting Started
02:31 Applying a Filter with the Calculate Function
05:02 Applying Multiple Filters
07:41 Combining Filters with the Or Operator
09:27 Using the IN Operator
10:51 Filters With Dates
12:37 Applying Date Filters with a Function
14:02 Referring to Multiple Columns in One Filter
16:54 Using the Filter Function to Reference Multiple Columns
19:03 Comparing Columns in a Filter Expression
20:56 Referring to Measures in Filters
22:56 Nesting Multiple Filter Functions
24:27 A New Example with AverageX
26:03 Using the CalculateTable Function
28:19 Limitations of Filters in CalculateTable
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!
Watch video DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 24 June 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 12,638 once and liked it 237 people.