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
863 reads
In this third part of this Power BI optimization series we look at how horizontal filtering and other changes can improve overall performance
2020-10-07
Companies use a Bell Curve approach to measure performance. As part of this approach they create a histogram. A histogram is a statistical concept and according to Wikipedia it is defined as a graphical distribution of the numerical data. A histogram is made of several bins and bins can be considered a range of values or a benchmark
2020-09-16
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,169 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
2,112 reads
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-21
In this article we look at the incremental refresh feature when working with Power BI data sources and how to implement for your reports.
2020-07-20
Data is stored in heterogenous environments in many organizations. Enterprise reporting for management and other departments is created using a variety of tools. There are Excel Workbooks, SSRS Reports, Tableau Dashboards, flat files, data streams from MySQL databases, etc. Each data extract or report is created by a BI or DB Development Team member. Often […]
2020-07-07
6,441 reads
Introduction Often at times, you may come across situations where you need to calculate a column repeatedly multiple times in the same Power BI report or across multiple reports. Although you can use the calculated columns to some extent, these are not robust and not reusable. In order to reuse the same piece of code, […]
2020-04-21
4,867 reads
Problem Many of us are already aware of the loopin...
2020-04-07
4,563 reads
By Steve Jones
This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...
By James-Serra
I have listed below the top questions I see from customers about Azure Synapse...
I’m pleased to announce that I will be presenting at PASS Summit. This year...
I'm working on a new app and database, which has real data types in...
I have an error Im looking into and I noticed that a datetime is...
All, I have a DEV server where the SSISDB database ended up in emergency...
Ask SSC