Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three DAX Time Intelligence functions related to the End of Periods: ENDOFMONTH(), ENDOFQUARTER(), and ENDOFYEAR(). 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 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.
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces four very similar DAX Time Intelligence functions related to Date: NEXTDAY(), NEXTMONTH(). NEXTQUARTER() and NEXTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
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.
You kick off a distributed job expecting it to finish in minutes — but...
By SQLPals
SQL Server instance metadata inventory with PowerShell and SMO The purpose...
Disclosure: this post may contain links to books as an affiliate link. If you...
Comments posted to this topic are about the item Fuzzy String Matching in SQL...
Comments posted to this topic are about the item Representing Money
Comments posted to this topic are about the item Celebrating 30 years of PostgreSQL,...
Which types of currency does the money data type represent?
See possible answers