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.

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.

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.

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.

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

By

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

Query compile/runtime issue

By as_1234

I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...

Job Opening for ERP Systems Administrator - Hybrid

By rdr1

Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...

Visit the forum

Question of the Day

Creating a JSON Document II

I want to create a JSON document that contains data from this table: 

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960
If I run this code, what document(s) is/are returned? 
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams n;

See possible answers