Forum Discussion
DAX basics - Task: Create a measure formula
Hi, i'm using the Contoso Dataset to try different DAX commands and I'm stuck at the first example. In this tutorial - https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-quickstar...
raul_pavel you should select a date range that has a quarter immediately preceding it in the dataset.
For example, try selecting 2018.
In your screenshot, with Year unfiltered and Quarter 1 selected, PREVIOUSQUARTER shifts the dates to the quarter immediately preceding the earliest date in the filter context, i.e. Q4 of 2004, which is a date range that doesn't exist in the dataset.
Hello Owen,
Thanks for the reply.
It seems that the only years with data for Previous Quartes Sales are 2012-2014. All other years returns a blank column. It would be weird though to left such a thing unmentioned in a tutorial.