Stairway Series

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,454 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 23: Time Intelligence – Dates Functions: The DAX PREVIOUS() Functions

  • Stairway Step

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.

4 (2)

You rated this post out of 5. Change rating

2024-01-16 (first published: )

1,063 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 22: Time Intelligence – Dates Functions: The DAX NEXT() Functions

  • Stairway Step

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.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

1,208 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 21: Time Intelligence – Dates Functions: FIRSTDATE() and LASTDATE()

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces two DAX Time Intelligence functions related to the Date: FIRSTDATE(), and LASTDATE(). 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: )

5,081 reads

Technical Article

Stairway to SQL Server Automated Database Testing

  • Stairway

Automated testing is a way to ensure you can repeatedly examine your code as you make changes by running a series of tests. Since these are automated, you have the ability to execute all tests with one programmatic call rather than hoping a developer runs all tests. This also allows the effort of writing tests […]

You rated this post out of 5. Change rating

2023-10-15 (first published: )

936 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 18: Time Intelligence Dates Functions

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces five DAX Time Intelligence functions related to Dates: DATESBETWEEN(), DATESINPERIOD(), DATESMTD(), DATESQTD(), and DATESYTD(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the functions in Power BI.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

2,158 reads

Blogs

The Book of Redgate: Meetings

By

I think we might have forgotten this a bit, but on one of the...

New article: Automating SQL Server Builds

By

I refresh my test SQL Servers at least monthly with a fresh VM. Setting...

Leading with Accountability: How Extreme Ownership Transforms Leadership

By

Embracing Total Responsibility In every organization there comes a moment when teams must choose...

Read the latest Blogs

Forums

Change Tracking Default Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Default Retention

ssrs subscription file share

By jshumaker

I am trying to create a subscription that posts to a one drive directory. ...

What is Delayed Durability in SQL Server — And Should You Turn It On?

By Chandan Shukla

Comments posted to this topic are about the item What is Delayed Durability in...

Visit the forum

Question of the Day

Change Tracking Default Retention

I run this command on my SQL Server 2022 database:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;
What is the default data retention period?

See possible answers