Powerpivot

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.

5 (1)

2022-11-23 (first published: )

4,870 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

  • Stairway Step

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.

2022-11-23 (first published: )

6,688 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 8: The DAX COUNT() and COUNTX() Functions

  • Stairway Step

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating counts to meet differing needs within our PowerPivot model designs.

2022-11-23 (first published: )

5,373 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 7: Function / Iterator Function Pairs: The DAX AVERAGE() and AVERAGEX() Functions

  • Stairway Step

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.

2022-11-23 (first published: )

4,259 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 6: The DAX SUM() and SUMX() Functions

  • Stairway Step

Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.

2022-11-23 (first published: )

6,924 reads

Blogs

Daily Coping 2 Feb 2023

By

Today’s coping tip is to challenge negative thoughts and look for the upside. I’m...

Deadline for Microsoft MVP contributions is 20 March 2023

By

Since changing to the new MVP renewal model, Microsoft MVPs have had until 31...

Why Managed Identities are Awesome

By

For the first workdays of this new year, I had the pleasurable task of...

Read the latest Blogs

Forums

Restrict available values from one parameter per othr parameters selected values

By catbeasy

Hello Have created a simple 9 column report where there are 7 (multi valued)...

Dimensional table and Stored Procedure

By yrstruly

To meet these requirements below, I came up with this SQL. Please evaluate my...

Anderson-Darling Calculation

By jackdanny816

Hi   I am following an article posted on sql server central on the...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers