DAX RANKX Function Behaviors Lead to Incorrect Results and Corrections
In this tip, we explore two behaviors for the DAX RANKX function that can lead to incorrect results and discuss workarounds and fixes.
2023-07-24
Power BI
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.
2024-01-16 (first published: 2023-07-19)
1,087 reads
Power BI Data Gateway to Connect Data Sources in the Cloud and On-Premises
In this article, learn how to set up and use Microsoft Data Gateway to connect data sources from various locations such as cloud or on-premises.
2023-07-17
Using Power BI to Analyze My Travels
As a data professional, I have some fun with data in my life. I like numbers, and I like tracking things. I've written posts about my year in numbers, and recently noted the states I've visited. Like many of you, I've sometimes used this data to practice a skill, maybe learn to ETL or query […]
2023-07-14
3,319 reads
Stairway to DAX and Power BI - Level 22: Time Intelligence – Dates Functions: The DAX NEXT() Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces four very similar DAX Time Intelligence functions related to Date: NEXTDAY(), NEXTMONTH(). NEXTQUARTER() and NEXTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2024-01-16 (first published: 2023-07-05)
1,234 reads
Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security
Microsoft Power BI is an interactive data visualization tool primarily designed with business intelligence in mind. Apart from being a visualization tool, it also has some built-in security features that we will discuss in this article.
2023-06-30
How to Reduce the Need for Bookmarks Using Parameters in Power BI
Learn how to implement parameters in Power BI.
2023-06-28
3,650 reads
Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security
In this article, learn how to control access levels to various data and parts of Power BI reports using row-level security as well as column and object-level security.
2024-01-09 (first published: 2023-06-19)
Multiple Relationships on the same Table in a Power BI Data Model
This article will cover how to create multiple relationships between the same tables in Power BI to build the data model you need.
2023-06-12
How to create a Sankey Chart in Power BI Desktop
Learn how to build and format a Sankey Chart using Power BI along with step-by-step instructions.
2023-02-27
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
The String Distance I
Comments posted to this topic are about the item The String Distance I
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers