This article describes how to compare time series that occur in different periods by standardizing the timelines to days since a specific event.  Read more

This article describes how you can use a scatterplot visual to make more effective Power BI reports.  Read more

This article provides examples of visual calculations where the use of EXPAND and COLLAPSE is required to obtain the correct result.  Read more

This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE.  Read more

This article introduces the VISUAL SHAPE clause, which defines a hierarchical structure for a table used in visual calculations.  Read more

Exciting news has just landed in the Power BI universe, and it’s set to transform the way we write formulas forever!  Read more

This article describes the different approaches to format your DAX measures in Power BI semantic models using format custom and dynamic format strings.  Read more

When you apply row-level security to a semantic model, there are limitations in using the USERELATIONSHIP function. This article shows the issues, provides a workaround, and its restrictions.  Read more

This article describes how to optimize time intelligence calculations with DirectQuery over SQL in Power BI by avoiding time intelligence DAX functions.  Read more

This article describes the difference between the results of DATEADD and PARALLELPERIOD in DAX. These differences also impact many other time intelligence functions that are syntax sugar of these two.  Read more