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.
2021-07-05 (first published: 2021-06-04)
In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.
2021-06-09 (first published: 2021-05-24)
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 […]
2020-11-04 (first published: 2020-10-09)
Learn about scalar user defined functions in this next level in the Stairway.
2020-10-21 (first published: 2020-10-08)