MDX in Power BI tutorial
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
11,538 reads
MDX
Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.
2024-01-16 (first published: 2020-09-02)
3,522 reads
2017-05-23
923 reads
MDX Calculations Across Multiple Calendars Using Nested SCOPEs
A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs
2016-10-10
2,817 reads
2015-09-17
1,313 reads
MDX Guide for SQL Folks: Part III - Advanced Analysis
Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.
2013-02-14
8,767 reads
Using MDX to Calculate Both Values and Percentages for Analysis Services
When creating pie charts using data from Analysis Services, having the MDX query calculate and return the percentages along with the counts or sums is extremely efficient. In this tip, we walk through an example of how this can be done.
2013-01-11
3,709 reads
MDX Guide for SQL Folks: Part II - Hierarchies and Functions
Learn everything about MDX by drawing only on your SQL knowledge.
2012-12-18
12,555 reads
MDX Guide for SQL Folks: Part I - Navigating The Cube
Learn all you need to know about MDX, by drawing only on your current SQL knowledge.
2014-06-13 (first published: 2012-11-01)
27,681 reads
Custom Rounding and Truncation of Numbers in MDX
MDX applies "bankers' rounding" algorithm in its ROUND() function. This article shows you how to avoid that and round like in T-SQL and Excel.
2009-10-06
4,622 reads
Blogs
Extending a SQL Server Failover Cluster Across Regions in Google Cloud Platform (GCP)
By davebem
I was the principal author of this SIOS whitepaper, which describes how to build...
Heading to 2024 PASS Summit
By Brian Kelley
I am able to head back to Seattle for the PASS Summit this year....
Tell me the positives of your solution
By Brian Kelley
I still have a tendency to talk about all the cons of a proposed...
Forums
The Cloud Security Problem
Comments posted to this topic are about the item The Cloud Security Problem
Virtualizing AWS data by using Fabric Shortcuts: Data Engineering with Fabric
Comments posted to this topic are about the item Virtualizing AWS data by using...
Timescale Brings PostgreSQL into the GenAI Era with pgai Vectorizer
Comments posted to this topic are about the item Timescale Brings PostgreSQL into the...
Question of the Day
The LAGging NULL
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers