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.
2024-01-16 (first published: 2023-03-01)
5,055 reads
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 […]
2023-10-15 (first published: 2023-02-22)
855 reads
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,126 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,185 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,258 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)
6,884 reads
2023-02-22 (first published: 2022-02-28)
2,277 reads
Learn how you can configure a Snowflake account in your cloud database and load data.
2024-10-31 (first published: 2021-12-01)
2,265 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,575 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.
2024-10-31 (first published: 2021-05-24)
3,739 reads
By Kevin3NF
The Source Control Dilemma Every DBA has been there. Trying to keep track of...
By Steve Jones
We recently published an article on CHOOSE at SQL Server Central. I thought it...
Introduction Treating your data catalog like a “data museum”—a static collection where information quietly...
Comments posted to this topic are about the item The Inefficiencies of Kubernetes
Comments posted to this topic are about the item The Backup Space Needed
Comments posted to this topic are about the item Implementing Fuzzy Search in SQL...
How do I calculate the amount of space needed for I/O buffers during a backup operation?
See possible answers