2022-04-22
9,550 reads
2022-04-22
9,550 reads
SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to build the reports.
2021-12-10
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.
2022-11-23 (first published: 2021-06-04)
1,462 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.
2022-11-23 (first published: 2020-10-14)
3,918 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.
2022-11-23 (first published: 2020-09-02)
2,996 reads
Problem A few weeks back, I got a request from a client of mine who had a very special requirement. They wanted to display values for a specific period in the past based on the selected dates in the Power BI report. Let us assume that if we select 30 June 2020, the report has to […]
2020-08-17
6,689 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.
2022-11-23 (first published: 2020-08-12)
6,039 reads
Introduction In response to my approach in the pop...
2020-06-22
7,280 reads
Introduction In response to my approach in the popular MDX Guide for SQL Folks series, I am using SQL as a good frame of reference for starting or developing a new approach for improving your Data Analysis Expression(DAX) language learning experience. This is useful for developers starting to learn the DAX language to more advanced developers who […]
2020-04-30
31,264 reads
Introduction In this article, I'll explain the use of the RANKX function available in DAX. The RANKX is a sortation function which is capable of performing a quite complex sorting and ranking based on the groups and values available in the dataset. It returns the ranking of a particular number available in each row of […]
2020-03-12
16,604 reads
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...
I am very excited and lucky to be speaking once again at SQLBits along...
Hi, I noticed that one of the database information is missing in sys.master_files catalog...
I'm running an index maintenance job on 1 of my large database as the...