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.
2021-07-05 (first published: 2021-06-04)
505 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.
2020-10-14
1,907 reads
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.
2020-09-02
1,523 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.
2020-08-12
2,247 reads
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
By John
You might be asking why on earth would you want to get a database...
Hi Everyone. i am planning to shift my website to AWS I want...
Hi Everyone, I'm trying to do something that seems pretty simple, but SQL Server...
Hello everyone, Again with this question. 🙂 I've got a log-shipped database, and I...
Ask SSC