Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces four very similar DAX Time Intelligence functions related to Date: PREVIOUSDAY(), PREVIOUSMONTH(). PREVIOUSQUARTER() and PREVIOUSYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot and DAX series.
Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.
Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX ISBLANK() function, and then provides some hands-on exposure to its use, particularly in combination with other DAX functions, in managing empty values underlying our PowerPivot model designs.
Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX SUM() and SUMX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in managing “sum” aggregations within our PowerPivot model designs.
Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson explores the DAX AVERAGE() and AVERAGEX() functions, comparing and contrasting the two. He then provides some hands-on exposure to the use of each, particularly in combination with other DAX functions, in generating arithmetic means within our PowerPivot model designs.
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.
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.
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.
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.
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers