Stairway Series

Stairway to DAX and Power BI

Level 27: Time Intelligence – Dates Functions: The DAX “Parallel Period” and “Same Period Last Year” Functions

  • Stairway Step

Business Intelligence Architect, “Analysis Services Maestro, and author Bill Pearson introduces two somewhat similar DAX Time Intelligence functions related to “parallel” Date periods: PARALLELPERIOD() and SAMEPERIODLASTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

You rated this post out of 5. Change rating

2024-01-24

1,200 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)

  • Stairway Step

The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]

5 (4)

You rated this post out of 5. Change rating

2023-12-06

1,457 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 3: Managing Code as a Team in Git

  • Stairway Step

In this level of the Stairway to Database DevOps, you'll get an introduction to branching and merging. Learn how to create a branch for making your changes to the codebase, submitting these in a code review, and then merging the changes into those made by other developers.

5 (2)

You rated this post out of 5. Change rating

2023-12-01

1,647 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 2: Manage Code with Red Gate SQL Source Control

  • Stairway Step

In this second level of the Stairway to Database DevOps, we learn to use Redgate's SQL Source Control to save and updates changes to objects, as well as tracking data in certain tables.

You rated this post out of 5. Change rating

2023-10-18

1,050 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: TOTALMTD(), TOTALQTD(), and TOTALMYD(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

5 (1)

You rated this post out of 5. Change rating

2024-01-16 (first published: )

818 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps

  • Stairway Step

In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.

5 (8)

You rated this post out of 5. Change rating

2023-10-16 (first published: )

2,366 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: CLOSINGBALANCEMONTH(), CLOSINGBALANCEQUARTER(), and CLOSINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

5 (1)

You rated this post out of 5. Change rating

2024-01-16 (first published: )

736 reads

Stairway to DAX and Power BI

Level 24: Time Intelligence – Dates Functions: The DAX OPENINGBALANCE*() Functions

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: OPENINGBALANCEMONTH(), OPENINGBALANCEQUARTER(). and OPENINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

1,325 reads

Blogs

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

By

I recently started full time learning of Amazon Web Services (AWS). I found that...

Read the latest Blogs

Forums

insert duplicate records with new timestamp

By Tara-1044200

how can i insert records from a transaction table into a transaction table with...

Performance benchmarking tools for SQL Server

By MichaelT

Are there any performance test tools that can check the performance of a SQL...

Backing up and Restoring a 3 terabyte database takes over 5 hours

By ericwenger1

I have a 3 terabyte database that is taking over 5 hours to backup...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers