Creating a simpler and chart-friendly Date table in Power BI
A Date table in Power BI can have a smaller number of columns by leveraging custom format strings to adequately control the chart visualization and the sort order. Read more
Understanding the difference between LASTDATE and MAX in DAX
This article explains why in many cases, MAX should be used instead of LASTDATE to search for the last date in a time period using DAX. Read more
Using calculation groups to selectively replace measures in DAX expressions
This article describes how to use calculation groups to dynamically replace only a partial expression in a complex DAX calculation. Read more
Creating KPIs in Power BI Desktop
This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Read more
Understanding LOOKUPVALUE
The LOOKUPVALUE function retrieves values from a table in a simple way, but it involves a hidden level of complexity. This article provides full coverage of the LOOKUPVALUE internals, alongside several performance considerations. Read more
Mark as Date table
Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. This article explains why this setting is required. Read more
Introducing LOOKUPVALUE
This article shows the reader how to use LOOKUPVALUE, which is a handy function for any developer to have in their toolbelt. Read more
Distinguishing HASONEVALUE from ISINSCOPE
This article describes the differences between HASONEVALUE and ISINSCOPE, which are two useful DAX functions to control the filters and the grouping that are active in a report. Read more
Sorting duplicated names in a level of a hierarchy with DAX
This article describes how to use DAX calculated columns to sort names that look like duplicates at a certain level of a hierarchy, but are unique when considering their full path within the hierarchy. Read more
Handling customers with the same name in Power BI
This article explains how to show different customers with the same name in a Power BI report by using zero-width spaces, thus simplifying the presentation without adding visible characters to make the names unique. Read more