# MDX in Power BI tutorial

• Article

Learn a bit about MDX and how you can incorporate it into your Power BI reports.

5 (3)

2022-11-07

# Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function

• Stairway Step

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.

4.5 (4)

2022-11-23 (first published: )

# Super Grand Total MDX

• QotD Question

2017-05-23

# MDX Calculations Across Multiple Calendars Using Nested SCOPEs

• Article

A solution to the problem of multiple calendar calculations within SSAS Multimdimensional cubes using nested SCOPEs

4 (2)

2016-10-10

# Stairway to MDX - Level 15: Basic Set Functions: The Tail() Function

• Stairway Step

Return, in order, a specified number of elements from the end of a set. SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Tail() function.

2019-03-26 (first published: )

• QotD Question

2015-09-17

# Stairway to MDX - Level 14: Basic Set Functions: The Head() Function

• Stairway Step

SSAS Maestro, SQL Server MVP and Business Intelligence Architect Bill Pearson introduces the MDX Head() function, which allows us to return, in order, a specified number of elements within a set.

2019-03-26 (first published: )

# Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions

• Stairway Step

BI Architect Bill Pearson continues with the third of a subseries surrounding a group of MDX functions we can use to support analysis and reporting in a time / date context. In this Level, we will explore the LastPeriods() and ParallelPeriod() functions, and get hands-on practice with each in meeting sample business requirements.

2022-07-27 (first published: )

# Stairway to MDX - Level 12: : MDX Time/Date Series Functions: OpeningPeriod() and ClosingPeriod() Functions

• Stairway Step

BI Architect Bill Pearson continues with the second of a set of articles surrounding a group of MDX functions specialized to support the analysis of data within the context of time / date. In this article, we will explore the OpeningPeriod() and ClosingPeriod() functions, and get hands-on practice with each in meeting sample business requirements.

2015-07-22

# Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions

• Stairway Step

BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.

2015-06-17

## Blogs

### Hyperconverged storage tuning tip for SQL Server

By

We all (should) know that running SQL Server in hyperconverged virtual environments, both on-premises...

### Daily Coping 25 Nov 2022

Today’s coping tip is to connect with someone from a different generation. This tip...

### Snowflake Classic UI vs Snowsight

This blog post is not about which User Interface is better, Classic or Snowsight...

## Forums

### TUYỆT CHIÊU CHẲM SÓC MAI VÀNG THÁNG 7 tới 10 ÂM LỊCH

By tt140411

TUYỆT CHIÊU CHẲM SÓC MAI VÀNG THÁNG 7 tới 10 ÂM LỊCH những chậu...

### Dumps With Pin :: Track 1 2 Shop Online

By dumpshop

WELCOME DEAR CUSTOMERS! Let us introduce you our dumps service Great Dumps Providing Dumps...

### DML Trigger Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item DML Trigger Limits

Visit the forum