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.
2024-01-16 (first published: 2023-03-01)
5,057 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.
2024-01-16 (first published: 2022-11-02)
2,131 reads
2022-04-22
10,422 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.
2024-01-16 (first published: 2020-10-14)
4,793 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.
2024-01-16 (first published: 2020-08-12)
7,771 reads
2020-05-29
481 reads
2020-05-22
611 reads
2020-05-15
818 reads
2020-05-08
662 reads
2020-05-01
539 reads
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Hi If value is 21000030 it should return 4 not 5 . In first...
This is one of those things very hard (for me)to explain in words. See...
Comments posted to this topic are about the item Feeling your age? How would...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers