第 4 节，共 37 节
DAX for Power BI Part 2.3 - The Switch Function
课时37 节课
- 1DAX for Power BI Part 1 - Getting Started with DAX for Power BI
- 2DAX for Power BI Part 2.1 - Basic Calculated Columns in DAX
- 3DAX for Power BI Part 2.2 - The If Function
- 4DAX for Power BI Part 2.3 - The Switch Function
- 5DAX for Power BI Part 2.4 - Working with Blanks
- 6DAX for Power BI Part 2.5 - Text in Calculated Columns
- 7DAX for Power BI Part 2.6 - Dates in Calculated Columns
- 8DAX for Power BI Part 2.7 - Error Functions in Calculated Columns
- 9DAX for Power BI Part 3.1 - Relationships and the Related Function
- 10DAX for Power BI Part 3.2 - The LookupValue Function
- 11DAX for Power BI Part 4.1 - Getting Started with Measures
- 12DAX for Power BI Part 4.2 - Sum, SumX and Other Aggregate Functions
- 13DAX for Power BI Part 4.3 - Counting Values and Rows
- 14DAX for Power BI Part 4.4 - Using Variables
- 15DAX for Power BI Part 4.5 - Quick Measures
- 16DAX for Power BI Part 5.1 - The Calculate, Filter and CalculateTable Functions
- 17DAX for Power BI Part 5.2 - Removing Filters in Measures
- 18DAX for Power BI Part 5.3 - Replacing and Keeping Filters in Measures
- 19DAX for Power BI Part 5.4 - Removing Filters with AllSelected and AllExcept
- 20DAX for Power BI Part 5.5 - The CrossFilter Function
- 21DAX for Power BI Part 6.1 - Introduction to Time Intelligence Functions
- 22DAX for Power BI Part 6.2 - Comparing Date Ranges
- 23DAX for Power BI Part 6.3 - Calculating Running Total or To Date Values
- 24DAX for Power BI Part 6.4 - Opening and Closing Balance Calculations
- 25DAX for Power BI Part 7.1 - Creating Basic Calendar Tables in DAX
- 26DAX for Power BI Part 7.2 - Creating a Financial Year Calendar
- 27DAX for Power BI Part 7.3 - Single Calendar vs Multiple Calendars
- 28DAX for Power BI Part 7.4 - Rolling Average Calculations
- 29DAX for Power BI Part 8.1 - The Values, HasOneValue and SelectedValue Functions
- 30DAX for Power BI Part 8.2 - The ConcatenateX Function
- 31DAX for Power BI Part 8.3 - Disconnected Slicers
- 32DAX for Power BI Part 8.4 - Disconnected Slicers and Conditional Formatting
- 33DAX for Power BI Part 8.5 - Field Parameters
- 34DAX for Power BI Part 9.1 - Ranking Values with the RANKX Function
- 35DAX for Power BI Part 9.2 - Ranking Values with the RANK Function
- 36DAX for Power BI Part 9.3 - Ranking with Substituted Values
- 37DAX for Power BI Part 10.1 - Context Transition