Bill Pearson


Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 17: Time Intelligence Functions: The DAX DATEADD() Function

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.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

2,618 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 18: Time Intelligence Dates Functions

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.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

2,165 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 2: The DAX COUNTROWS() and FILTER() Functions

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.

5 (1)

You rated this post out of 5. Change rating

2024-01-16 (first published: )

23,662 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 20: Time Intelligence – Date Functions: ENDOFMONTH(), ENDOFQUARTER(), ENDOFYEAR()

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.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

1,162 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 21: Time Intelligence – Dates Functions: FIRSTDATE() and LASTDATE()

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.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

5,092 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 22: Time Intelligence – Dates Functions: The DAX NEXT() Functions

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.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

1,215 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 23: Time Intelligence – Dates Functions: The DAX PREVIOUS() Functions

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.

4 (2)

You rated this post out of 5. Change rating

2024-01-16 (first published: )

1,070 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

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.

You rated this post out of 5. Change rating

2024-01-16 (first published: )

11,444 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 5: The DAX ISBLANK() Function

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.

5 (1)

You rated this post out of 5. Change rating

2024-01-16 (first published: )

8,076 reads

Blogs

Trace Flag 1448 – Lessons from a Technical Interview

By

In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...

Disable the sa login in SQL Server (and sleep better)

By

Disable the sa login in SQL Server (and sleep better)If you run SQL Server...

Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation

By

Change is inevitable. What separates thriving organizations from those that falter is not the...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Be Wary of Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Be Wary of Data

Locking Hierarchies

By Uwe Ricken

Comments posted to this topic are about the item Locking Hierarchies

Visit the forum

Question of the Day

Locking Hierarchies

You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:

SELECTo_orderdate,
        o_orderkey,
        o_custkey,
        o_storekey
FROMdbo.orders
WHEREo_orderkey = 3877;

What locking hierarchy will Microsoft SQL Server use?

 

See possible answers