By Andrew Gould
Download files here 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 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 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!
5 авг 2024
