MDX in Power BI tutorial
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
9,683 reads
Learn a bit about MDX and how you can incorporate it into your Power BI reports.
2022-11-07
9,683 reads
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,396 reads
2017-05-23
920 reads
A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs
2016-10-10
2,773 reads
2015-09-17
1,310 reads
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,631 reads
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
Learn everything about MDX by drawing only on your SQL knowledge.
2012-12-18
12,206 reads
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,371 reads
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,570 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
We're trying to understand how quick new versions of SQL server can be. Obviously...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers