Bill Pearson

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot and DAX series.

2013-10-09 (first published: )

9,367 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 2: The DAX COUNTROWS() and FILTER() Functions

Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.

2013-09-11 (first published: )

14,396 reads

Stairway to MDX

Stairway to MDX - Level 10: “Relative” Member Functions: .CurrentMember, .PrevMember, and .NextMember

SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces three “major players” within the MDX “relative” functions. These basic, but highly employed, functions include the .CurrentMember, .PrevMember and .NextMember functions.

2013-06-12

5,021 reads

Blogs

New Event Calendar

By

Speaking Engagements Check out my new Event Calendar, to see my upcoming and past...

Databricks Delta Lake

By

Introduced in April 2019, Databricks Delta Lake is, in short, a transactional storage layer...

Get the Governance Data You Need Out of Your Power BI Gateways with PowerShell

By

OK, before anyone yells at me: Yes, I know the On-Premises Data Gateways are...

Read the latest Blogs

Forums

More Network Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Network Restrictions, which is...

Creating a Skeleton Data Frame

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a Skeleton Data Frame

Experiment First

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Experiment First

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers