Display Active Slicers in Power BI using Dynamic DAX
Learn how to enhance visibility using slicers in Power BI for better report filtering and user experience.
2026-06-15
DAX
Level 28: DAX Text Functions: The DAX Extract & Modify Functions: LEFT(), RIGHT(), MID(), REPLACE(), SUBSTITUTE()
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
2026-02-04
1,620 reads
DAX CASE Statement Functionality using IF, SWITCH and SWITCH True
If you don’t know, DAX (Data Analysis Expressions) is a language for creating custom calculations and aggregations in Power Pivot, Power BI, and other data analysis tools. Two functions in DAX come close to replicating the functionality but come with limitations. Which one of these functions should you use?
2025-04-04
INFO.VIEW DAX Functions Usage and Examples
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
Dynamically Create Tables in Power BI with DAX Functions
Learn about DAX functions to use in Power BI ADDCOLUMNS, CROSSJOIN, VALUES, SUMMARIZE, GENERATE, CALENDAR, FILTER, TOPN, UNION, and NATURALINNERJOIN.
2024-02-21
Level 27: Time Intelligence – Dates Functions: The DAX “Parallel Period” and “Same Period Last Year” Functions
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.
2026-04-15 (first published: 2024-01-24)
1,921 reads
Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions
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.
2026-04-15 (first published: 2023-09-27)
985 reads
Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions
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.
2026-04-15 (first published: 2023-08-30)
892 reads
Level 24: Time Intelligence – Dates Functions: The DAX OPENINGBALANCE*() Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: OPENINGBALANCEMONTH(), OPENINGBALANCEQUARTER(). and OPENINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2026-04-15 (first published: 2023-08-23)
1,540 reads
Stairway to DAX and Power BI - Level 23: Time Intelligence – Dates Functions: The DAX PREVIOUS() Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces four very similar DAX Time Intelligence functions related to Date: PREVIOUSDAY(), PREVIOUSMONTH(). PREVIOUSQUARTER() and PREVIOUSYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2026-04-15 (first published: 2023-07-19)
1,137 reads
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers