Business Intelligence with Power BI
Writing measures in DAX is relatively easy to learn. But more complex calculations are not possible with simple measures like SUM () or COUNTROWS (). To understand this, we need to look at the way how DAX calculates values.
Read more
Data from the Power Pivot data model can be displayed in Excel in pivot tables or pivot charts. Sometimes, however, it is necessary to create a DAX query and load the data into an Excel spreadsheet. This was possible until Excel 2013 (maybe in 2016 as well). In this article I show you, how DAX Query Tables can be created in Excel 2019.
Read moreHits: 19730The use of user roles is an essential element for restricting or preventing access to the data. The following
Read moreHits: 3139When displaying value changes over time, the past values, the current values and the planned values are often in
Read moreHits: 5577With the Power BI Desktop April 2017 release (see here), Microsoft introduced a few game changers. There are Quick
Read more
