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
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
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,028 reads
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
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
2,971 reads
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,178 reads
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
Learn how to implement parameters in Power BI.
2023-06-28
3,390 reads
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)
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
Learn how to build and format a Sankey Chart using Power BI along with step-by-step instructions.
2023-02-27
I’ve covered how to create Elastic Jobs in the portal (this one is important...
By Steve Jones
redesis – n. a feeling of queasiness while offering someone advice, knowing they might...
By Steve Jones
The Solutions Engineers at Redgate recently released an Introduction to Redgate Flyway Autopilot course...
Comments posted to this topic are about the item No End to Programmers
Hi there to all SQL gurus So, here is the scenario. I have a...
Guys, I am facing problems when running a backup routine JOB in SQL Server,...
What is the result of this query in SQL Server 2022+?
select bit_count('7')See possible answers