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.
2024-01-16 (first published: 2022-11-02)
2,199 reads
Learn how you can query for patterns in the Abstract Syntax Tree to analyze your code.
2023-02-22 (first published: 2022-06-08)
2,441 reads
In this level of the Stairway to ScriptDOM, we examine the way the tool parses scripts and creates tokens from the text.
2023-02-22 (first published: 2022-04-13)
4,808 reads
Get an introduction to the Stairway Series and learn about the power of the ScriptDOM library.
2023-02-22 (first published: 2022-03-09)
7,617 reads
2023-02-22 (first published: 2022-02-28)
2,533 reads
Learn how you can configure a Snowflake account in your cloud database and load data.
2025-06-13 (first published: 2021-12-01)
2,650 reads
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.
2024-01-16 (first published: 2021-06-04)
2,677 reads
In this next level of the Stairway to Snowflake, we look at the considerations for creating an account and how to set one up.
2025-06-13 (first published: 2021-05-24)
4,060 reads
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
2025-06-13 (first published: 2021-02-17)
11,754 reads
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.
2024-01-16 (first published: 2020-10-14)
4,923 reads
By Steve Jones
I come to Heathrow often. Today is likely somewhere close to 60 trips to...
By Brian Kelley
If your organization is spending money, then meaningful results are a must. Pen testing...
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers