period

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

Blogs

The trade-offs associated with low-code solutions

By

Low-code solutions often accelerate development and make tasks accessible to people who can’t or...

Monday Monitor Tips: Looking Back in Time

By

Often we find out about a problem reported by a customer after the incident...

Can You Tell Why a Plan Didn’t Go Parallel?

By

Let’s face it, most of the time, you probably don’t want your SQL Server...

Read the latest Blogs

Forums

Is there a way to determine an Azure Data Factory Trigger's "next run time"?

By Orlando Colamatteo

Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...

The Table Backup

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Table Backup

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Visit the forum

Question of the Day

The Table Backup

I run this code in SQL Server 2022. What happens?

BACKUP TABLE beercount TO DISK = 'beercount.bak'
 

See possible answers