Bill Pearson


Technical Article

Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLEXCEPT() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLEXCEPT(), focusing largely upon its most popular use in removing filters from all columns in a table - except the filters we specify.

5 (1)

2021-09-24 (first published: )

2,922 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.

4.33 (3)

2021-09-15 (first published: )

2,361 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CALCULATE() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to CALCULATE(), focusing largely upon its most basic uses in evaluating an expression in a context that is modified by specified filters.

5 (1)

2021-09-08 (first published: )

3,737 reads

Stairway to DAX and Power BI

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

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)

2021-09-01 (first published: )

4,549 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.

5 (1)

2021-08-25 (first published: )

4,509 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 11: Function / Iterator Function Pairs: The DAX Concatenate() and ConcatenateX() Functions

Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.

2021-08-18 (first published: )

4,916 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 10: Function / Iterator Function Pairs: The DAX Product() and ProductX() Functions

As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX Product()and ProductX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Product()and ProductX(), respectively, in returning the product of numbers in a column and in returning the product of an expression evaluated for each row in a table.

5 (1)

2021-08-11 (first published: )

4,663 reads

Technical Article

Stairway to DAX and Power BI - Level 17: Time Intelligence Functions: The DAX DATEADD() Function

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX DATEADD() function, discussing its syntax, uses and operation. He then provides hands-on exposure to DATEADD(), focusing largely upon a popular use in creating prior-period values at multiple Date hierarchy levels.

2021-07-05 (first published: )

750 reads

Blogs

Dec 8 Webinar with Pavilion – Boost SQL Server on VMware Performance 400% with 2-Step Tuning

By

Join us on December 8th at 10am Pacific time for an exciting new webinar!...

Daily Coping 3 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 2 Dec 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Foreign key in the column values of another table

By teb

I have trouble in writing a SQL query. I have a data table with...

How to increase performance to load a factless date-date-interval table

By svenflock

Hi all, I am currently having performance issues by populating one of my factless...

Linked Server Error

By dhara

Hi Experts, I am getting the following error when i am trying to test...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers