As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX COUNT() and COUNTX() 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 counts to meet differing needs within our PowerPivot model designs.

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.

Stairway to DAX and Power BI - Level 8: The DAX COUNT() and COUNTX() Functions

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

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

Understanding Fabric MCP

AWS RDS Aurora - our first approach

Forums

SSC Spam

BCA KCP Kawi No.Telpon:083135765355

BCA KCP Sukun No.Telpon:083135765355

Question of the Day

May the Fourth Be With You Fun