We help you grow your company by implementing top class business intelligence systems!
Implementation and Education!
PowerBI / PowerApps / Excel
for the analysis of financial statements, such as P&L, Balance Sheet, Cash Flow, and Gross Balance Sheet.
We can guide you throughout the whole experience, how ?
We enjoy sharing our knowledge and gained over 1000 subscribers by posting videos about Power BI and Power Query topics! Check out our channel!
We have written over 60 different PowerBI articles. We are most proud of our DAX Handbook series on the basics of the DAX language.
Variables are used in almost every measure you will create. The reason we introduce them last is that they use all other parts of DAX code to produce faster, more powerful and maintainable code. Variables are like containers of a part of the DAX code which can be used throughout your measure. Few facts about
Explanation ALLSELECTED is one of the most complex functions in DAX. When used improperly it can lead to unexpected results. As a rule of thumb, you should not use it in iterative functions. It is preferable to use it only as a CALCULATE filter remover, not as a table function. ALLSELECTED comes into play once
What is Lineage? Lineage is a part of DAX mechanics that enables us to use tables as filter arguments for the CALCULATE function. It’s also used in row2filter context transition and other aspects of the data model that involve filter propagation throughout the model. We can state that lineage is the possibility to filter the
Crossfilter is a feature of DAX when it filters the underlying dataset even though there aren’t any visual filters present. Introduction In this example, we will explain a very important feature of CALCULATE filter arguments. We will also explain why you should always prefer the combination of ALL/REMOVEFILTER + VALUES instead of ALLEXCEPT function. We
Learn With Exceed Academy
Improve your skills in our Exceed Academy, tailored for both beginners and professional.
GET A QUOTE
For more information, please contact us through the form
Our team will answer you in a timely manner.