DAX Cookbook

Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R08_Sales that contains the following data:

Quarter	Year	Sales
1	2013	47
2	2013	49
3	2013	53
4	2013	44
1	2014	43
2	2014	55
3	2014	58
4	2014	48
1	2015	44
2	2015	43
3	2015	58
4	2015	49

3. Use an Enter Data query to create a second table called R08_Wages that contains the following data:

Quarter	Year	Wages
4	2012	19.25
1	2013	18.5
2	2013	17.75
3	2013	17.7
4	2013	18
1	2014	20
2	2014	18.75
3	2014	18.7
4	2014	18.25
1	2015