DAX

Stairway to DAX

Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions

  • Stairway Step

Business Intelligence Architect, Data Analyst, CPA, and author Bill Pearson continues a subseries surrounding the DAX Text Functions, and breaks out the next operational group within Text functions, the “Combine and Aggregate Functions” group, including the CONCATENATE(), CONCATENATEX, and COMBINEVALUES() functions as the focus of this Level. He identifies and examines each functional member of this “Combine and Aggregate” group, discussing for each its respective syntax, uses, and operation, while providing hands-on exposure to it in Power BI.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2026-10-28

1,187 reads

Stairway to DAX

Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()

  • Stairway Step

Business Intelligence Architect, Data Analyst, CPA, and author Bill Pearson introduces a subseries surrounding the DAX Text Functions, including LEFT(), RIGHT(), MID(), REPLACE(), and SUBSTITUTE() and breaks out the operational groups of functions involved. Next, he introduces the “Extract and Modify” group of text functions as the focus of this Level. Finally, he identifies and examines each functional member of the “Extract and Modify

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2026-02-04

1,774 reads

External Article

INFO.VIEW DAX Functions Usage and Examples

  • Article

In the December 2023 Microsoft Power BI Desktop release, more than 50 new INFO DAX functions were added. They all start with “INFO.” and return the same result as corresponding data management views (DMVs) that were available before only using a SQL-like syntax. With these new DAX functions, you can use the recently added DAX query to get metadata about your semantic mode

2025-03-10

Stairway to DAX and Power BI

Level 27: Time Intelligence – Dates Functions: The DAX “Parallel Period” and “Same Period Last Year” Functions

  • Stairway Step

Business Intelligence Architect, “Analysis Services Maestro, and author Bill Pearson introduces two somewhat similar DAX Time Intelligence functions related to “parallel” Date periods: PARALLELPERIOD() and SAMEPERIODLASTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2024-01-24

2,066 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: TOTALMTD(), TOTALQTD(), and TOTALMYD(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2023-09-27

1,081 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: CLOSINGBALANCEMONTH(), CLOSINGBALANCEQUARTER(), and CLOSINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2023-08-30

985 reads

Blogs

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates

By

This week I was at PASS Data Community Summit in Seattle, and I attended...

Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents

By

(This is the third post in a three-part series on how AI is changing...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance, which is...

People Matter

By Grant Fritchey

Comments posted to this topic are about the item People Matter

Helping an English Student with R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Helping an English Student with...

Visit the forum

Question of the Day

Adding Bits I

I have a table, dbo.bittest, where I am testing an application response. This has this structure: 

CREATE TABLE [dbo].[BitTest]
(
[insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()),
[a] [bit] NULL
) ON [PRIMARY]
GO
My application runs this code: 
INSERT dbo.BitTest
(
    insertdate,
    a
)
VALUES
(DEFAULT, 'true')
GO

See possible answers