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.
2026-04-15 (first published: 2023-07-05)
1,269 reads
Judging from my experience working with business stakeholders across several organizations, slicing data by current week, previous week, two weeks ago, and so on has become a requirement for reporting. I will demonstrate a simple approach to achieve this requirement.
2023-05-01
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.
2026-04-15 (first published: 2023-03-01)
5,135 reads
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.
2026-04-15 (first published: 2022-11-02)
2,233 reads
2022-04-22
10,523 reads
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLEXCEPT() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLEXCEPT(), focusing largely upon its most popular use in removing filters from all columns in a table - except the filters we specify.
2026-04-15 (first published: 2020-10-14)
4,960 reads
Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CALCULATE() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to CALCULATE(), focusing largely upon its most basic uses in evaluating an expression in a context that is modified by specified filters.
2026-04-15 (first published: 2020-08-12)
7,860 reads
2020-05-29
490 reads
2020-05-22
624 reads
2020-05-15
826 reads
Say you need outside help. You’ve exhausted all the things that you could do...
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
WA:08218154393 Citraland, Gateway Junction, Jl. Ruko No.1&2 Blok TL06, Lidah Kulon, Kec. Lakarsantri, Surabaya,...
WA:08218154393 Jl. Raya Prapen No.38, Sidosermo, Kec. Wonocolo, Surabaya, Jawa Timur 60299
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers