Iterative functions have one special ability, and that is to form a “Virtual” row context for the table supplied as an argument. Table vs Scalar Iterative Functions The most used iterative functions are: SUMX, MINX, MAXX, AVERAGEX, CONCATENATEX, COUNTX, RANKX Pretty much any function ending with X All those functions have 2 things in common, …
When first getting acquainted with DAX and modeling, it’s confusing when to create calculation logic in a Calculated Column and when to use Measures. Quite often novice users try to push all calculations to Calculated Columns, then drag them to the Values field of the visual (making an implicit Measure) or performing a simple Explicit …
DAX HANDBOOK
2.3 Columns vs Measures (Implicit vs Explicit Measures) Read More »
Columns Overview In general, the data model consists of Tables. Tables consist of Columns. Columns are used to form Filter context by plotting them on the canvas in filter fields. They are also used as building blocks of DAX Measures. We can say that columns are the most used objects in data modeling. In import …
Measure Explanation Measures are the most important objects in your data models. They are the ones that provide dynamic results based on different combinations of filters plotted on visuals. They are also the most complex ones since they change results with each interaction in a report. To be able to produce the correct result while …
DAX Demystified DAX is a functional language. It consists of more than 250 functions. This seems like a lot right? Learning how to properly use 250+ functions seems like a daunting job, but here is the secret. You do not need to learn by heart all of them but instead try a different approach. DAX …
What is DAX? DAX (Data Analysis Expressions) is a functional programming language used to manipulate with several Microsoft BI tools. Microsoft BI tools that use DAX: PowerBI (Tabular model) Excel (PowerPivot) Analysis Services (Tabular model) With DAX you are able to “talk” with the data model, adjust it using calculated columns or return results from …
We can define coalesce in PowerQuery as the last value existing in a single row of multiple columns positioned from left to right. In our example that would be the last value from the month columns. In this article, we will show you how to create both static and dynamic formulas for coalescing. If you …
Let us imagine the following scenario. We have multiple clients sharing their sales data with us. They store the data in dedicated folders that reside in different places. The number of clients, as well as the number of files for each client, will vary across periods. We wish to create an automatic refresh system that …
How to process multiple folders with a single PowerQuery script Read More »
This is the second part of the blog series dedicated to showing workarounds for currently unsupported matrix visual features. In the first part, we explained how to add conditional formatting only for the specified columns. In this article, we will explain how to introduce sorting. Below, you can test a working example in the embedded …
Sorting in Matrix created with calculation groups (PowerBI) Read More »
This is going to be the first of 2 articles explaining how to introduce conditional formatting and sorting when using calculation groups in Matrix visual. It would be great if conditional formatting and sorting could be applied to a calculation item, but until this happens, here is a workaround. Link to the second part of …
Conditional formatting with Calculation Groups in PowerBI Matrix visual Read More »
EXCEED Solutions d.o.o.
Drežnička 21, 10000 Zagreb, Hrvatska
OIB: 25417969805
MBS: 081124327
IBAN: HR6523600001102641074
info@exceed.hr
+385 98 9461 471
Ured: Modruška 2, 10000 Zagreb
Designed and powered by Adssential
