Topic: Power BI
-
This article describes how to compute previous year values up to a certain date. This is useful in case the data is presenting incomplete months or years. Read more
-
The June 2019 update of Power BI includes the ability to filter slicer items based on a measure. This article explains why this is an important feature that should replace bidirectional filters used for the same purpose. Read more
-
In the 2015 September update, Power BI introduced calculated tables, which are computed using DAX expressions instead of being loaded from a data source. This article shows the usage of calculated tables to solve the pattern of transition matrix for… Read more
-
This article describes how DAX Studio can analyze the SQL queries sent to a relational database by Power BI or Analysis Services Tabular in DirectQuery mode. Read more
-
This article introduces a technique to filter and productively compare two time periods with Power BI. Read more
-
This article describes how to implement currency conversion for reporting purposes in Power BI. Read more
-
If you do not have a full month with data, comparisons such as year-over-year (YOY) might require particular filters in order to do a like for like comparison in DAX. This article describes how to write DAX expressions comparing equivalent… Read more
-
This article analyzes how to efficiently work with events that lasts over time, such as the duration of an order considering the distance between order date and ship date. Read more
-
In Power BI Desktop (as of February 2016) you have to use DAX to apply calculations over dates (such as year-to-date, year-over-year, and others), but you do not have the Mark as Date Table feature. This article describes which scenarios… Read more
-
This article shows a technique in DAX to compute the sales volume of products that were available right from the beginning of a selected time period, ignoring products introduced afterwards. Read more