Topic: DAX

        376 posts
article –

The importance of star schemas in Power BI

Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! This article shows why a star schema can fix some of the issues in your report.  Read more

article –

Naming temporary columns in DAX

This article describes a naming convention for temporary columns in DAX expressions to avoid ambiguity with the measure reference notation.  Read more

DAX 101 –

Previous year up to a certain date

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

article –

Blank row in DAX

There are two functions in DAX that return the list of values of a column: VALUES and DISTINCT. This article describes the difference between the two, explaining the details of the blank row added to tables for invalid relationships.  Read more