Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

by Bill Pearson

SQLServerCentral.com

As a part of his "Function / Iterator Pairs" mini-series, Business Intelligence architect, Analysis Services Maestro, SQL Server MVP, and author Bill Pearson introduces the DAX MAX() and MAXX() functions, discussing similarities and differences. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating "largest numeric values" to meet differing needs within our PowerPivot model designs.

Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR()

by Bill Pearson

SQLServerCentral

Uncategorized

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the Start of Periods: STARTOFMONTH(), STARTOFQUARTER(), and STARTOFYEAR(). He discusses the syntax, uses and operation of each, and then provides hands-on exposure to the function in Power BI.

Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions

by Bill Pearson

SQLServerCentral

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: CLOSINGBALANCEMONTH(), CLOSINGBALANCEQUARTER(), and CLOSINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions

by Bill Pearson

SQLServerCentral

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: TOTALMTD(), TOTALQTD(), and TOTALMYD(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.

Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE

by Vishnu Gupthan

SQLServerCentral

The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.

Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE

by Vishnu Gupthan

SQLServerCentral

This next level of the Stairway to TDE shows how to upgrade your EKM cryptographic provider.

Who is Irresponsible?

by Steve Jones

SQLServerCentral

It can be irresponsible to use AI, but is it in many cases? Steve has a few thoughts.

How to Draw Line Graphs in SSMS

by Additional Articles

Brent Ozar Blog

Ever just need a quick visualization of some numbers to get a rough idea of the trend, like this

Poor Names

by Steve Jones

SQLServerCentral

Database Design and Implementation

Naming objects becomes surprisingly difficult in software.

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

by Ted

SQLServerCentral

Career Growth

What a DBA team actually deals with There are many issues a DBA team faces, from servers going down to login access not being requested on time. These are not glamorous problems, but they are the problems that stop everyone else doing their jobs. In a modern environment you would expect a lot of the […]

Stairway to DAX and Power BI - Level 9: Function / Iterator Function Pairs: The DAX MAX() and MAXX() Functions

Stairway to DAX and Power BI Level 19: Dates Functions: STARTOFMONTH(), STARTOFQUARTER(), STARTOFYEAR()

Stairway to DAX and Power BI Level 25: Time Intelligence – Dates Functions: The DAX CLOSINGBALANCE*() Functions

Stairway to DAX and Power BI Level 26: Time Intelligence – Dates Functions: The DAX “Total to Date” Functions

Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE

Updating a Cryptographic Provider for EKM with Azure Key Vault - Level 5 of the Stairway to TDE

Who is Irresponsible?

How to Draw Line Graphs in SSMS

Poor Names

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

Blogs

Overcoming Imposter Syndrome: A Plan

Advice I Like: Celebrate Success

Programmatically Retrieving MLV Lineage and Refresh Times

Forums

How are you handling sensitive data when using AI for queries or transformations

BCA KCP Jalan Panjang TLP/WA 08216977749

BCA KCP Daan Mogot Dua TLP/WA 08218573837

Question of the Day

May the Fourth Be With You Fun