Bill Pearson

Stairway to DAX and Power BI

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

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.

2019-09-11 (first published: )

5,289 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.

2019-06-12 (first published: )

3,284 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)

2019-06-05 (first published: )

2,950 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)

2018-01-31

959 reads

Stairway to MDX

Stairway to MDX - Level 5: Members, and an Introduction to the MDX Members Functions

Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension

2018-01-17 (first published: )

8,596 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.

2017-11-29

894 reads

Blogs

Join me at SQLBits 2020

By

The SQLBits conference is taking place in London again this year, between March 31st...

DBA, a job, a vital job

By

DBA, a job, a vital job. T-SQL a language that is fun. Select, a...

SOS_SCHEDULER_YIELD – What is it really telling us?

By

I decided to write this off the back of a conversation I was having...

Read the latest Blogs

Forums

SMO Certificate Export - FailedOperationException

By BPRocket

Greetings, Given this Powershell SMO method call... $_cert.Export("$CertificateLocation\$_cert_name.cer", ` "$PrivateKeyLocation\$_cert_name.pvk", ` $_secret) where $_cert...

Resultset in a format

By VSSGeorge

I have the following tables: create table #EmployeeSystemsMaster(EmployeeSystemID int, EmployeeSystemName nvarchar(150)) insert into #EmployeeSystemsMaster...

SQL Server data masking

By Admingod

Can you able to mask data in sql server 2012? If yes, would it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers