Stairway Series

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.

2022-04-05 (first published: )

975 reads

Technical Article

Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function

  • Stairway Step

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLEXCEPT() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLEXCEPT(), focusing largely upon its most popular use in removing filters from all columns in a table - except the filters we specify.

5 (1)

2022-04-04 (first published: )

3,587 reads

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 11: Using Logical Operators

  • Stairway Step

SQL Server supports a number of different logical operators.  These operators can be used for testing Boolean conditions that return true, false and unknown in your T-SQL code.  Logical operators are useful for defining constraints to limit the rows be processed when selecting or updating data. This chapter will provide an overview of the logical […]

4 (1)

2022-04-20 (first published: )

3,338 reads

Blogs

Alert Filtering in SQL Monitor

By

SQL Monitor has improved a lot over the last couple of years. We have...

SharePoint List only returns 100 items in Azure Logic App

By

I was reading a SharePoint List using the “Get Items” activity in an Azure...

Daily Coping 27 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

transaction log backup for log shipping vs manual backup

By sqlfriend

If I setup log shipping for a database, and I want to do a...

Veritas Net Backup

By ramana3327

Hi, We are using SQL 2014 version. The scheduled backup job is failing with...

Database backup and restore

By DBA

Hello, I've a user database which I want to migrate to new server, so...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers