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,106 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
1,844 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,384 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,209 reads
Problem Many of us are already aware of the loopin...
2020-04-07
4,393 reads
Introduction Reporting on web data has been a fascinating part of developing any dashboard or reports in Power BI. Often this data is available either free that can be consumed anonymously or by using some kind of authentication mechanism. In this article, I'm going to demonstrate how to connect to a web application from Power […]
2020-03-17
3,161 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
9,116 reads
By gorandalf
A long time ago, in early days of the Azure SQL Database in 2015,...
By Rayis Imayev
(2020-Sep-26) Last week one of my Azure Data Factory (ADF) deployment pipelines failed with an...
By kleegeek
Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...
what kind of situation can I use "option (fast 1)" when I execute a...
During the installation I come to the step of configuring the database engine. It...
Comments posted to this topic are about the item A Getting Started PostgreSQL Tutorial
Ask SSC