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)
789 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,074 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,105 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,041 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,654 reads
2023-02-22 (first published: 2022-02-28)
2,184 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,159 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,525 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,557 reads
Get an overview of Snowflake in this level, one of the fastest growing data warehouse platforms in the world.
2024-10-31 (first published: 2021-02-17)
10,514 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...