From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Understand lesson 12 exercises: Parameters

Understand lesson 12 exercises: Parameters

From the course: Mastering Business Intelligence with DAX, Power BI, and Excel by Microsoft Press

Start my 1-month free trial Buy for my team

Understand lesson 12 exercises: Parameters

“

- First exercise for Lesson 12 is about numeric range parameters. The goal is to create a dynamic month comparison. You need to create a parameter with the values one through six and then create a measure that uses this parameter to compare the sales for the current context with the sales of an earlier month. And we gave you the hint to use DATEADD here. The second exercise is to use field parameters. In this exercise, the goal is to create dynamic monthly results. Create a field parameter for the Sales, Number Sold, and Average Price measures, and create a chart that allows the report user to dynamically select one or more of these measures and that shows the results by month. So to create a numeric parameter, we go to Modeling, New Parameter, Numeric Range. Now, probably most difficult part here is giving this thing a name. So let's call this MonthComparison. It's a whole number and I want that to be between one…

Contents