Stairway Series

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,037 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: )

825 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,110 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 17: Time Intelligence Functions: The DAX DATEADD() Function

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX DATEADD() function, discussing its syntax, uses and operation. He then provides hands-on exposure to DATEADD(), focusing largely upon a popular use in creating prior-period values at multiple Date hierarchy levels.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

2,557 reads

Blogs

Using T-SQL Snapshot Backup - Multi-Array Database Snapshots

By

In this post, the fourth in our series, I want to share an example...

AIs Struggle with Family

By

This post looks at a logic problem asked to an AI, and which is...

Advice I Like: Why am I doing this?

By

You are never too young to wonder “Why am I still doing this?” You...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Building SSIS Custom Task

By bodempudi111

Hi Everyone, Greetings of the day! I am working on building SSIS Custom task...

Visit the forum

Question of the Day

Precision and Scale I

I have this number: 456.23 What is the scale of this number?

See possible answers