Mastering Microsoft Power BI

Current and prior periods

A common requirement of date intelligence metrics is to compare the YTD total for a measure versus the equivalent time period of the prior year. For example, on November 14, 2017, the visual would compare January through October of 2017 versus January through October of 2016. Without any external filtering, however, a standard YTD measure would include the 14 days of November in 2017 and would capture the entire year of 2016 if the year 2016 was in the filter context. To deliver equivalent or apples to apples comparisons of equal time periods, the filter context of measures can be further customized.

The following measures retrieve the year-to-date net sales through the prior calendar month and prior calendar week. ...