Power BI DAX What-if Parameters

£45.00£1,350.00

Power BI DAX What-if Parameters by G Com Solutions is a short course which focuses on the use of disconnected parameter tables to add flexibility to your Power BI reports by allowing the user to customize the results produced by some of your key metrics.

Clear
SKU: GCOL-PBI-DWP Category:

Description

Power BI DAX What-if Parameters by G Com Solutions is a short course which focuses on the use of disconnected parameter tables to add flexibility to your Power BI reports by allowing the user to customize the results produced by some of your key metrics.

We begin the course by discussing the use of Power BI’s built-in What-if parameter feature and analysing what it actually does behind the scenes.

One of the key limitations of Power BI’s built-in feature is that it can only be used with numeric parameters. So, the course then shows you how to extend this feature by creating and implementing your own custom parameter tables.

And we use the parameters feature as a launchpad to the creation of a sophisticated currency conversion dashboard which gives us a chance to practice other useful techniques, such as the inclusion of custom visuals in your reports, the use of DAX variables to make your formulas clearer and easier to maintain, and how to provide useful interactive feedback to your users by creating dynamic titles driven by complex DAX formulas.

So, if you’re looking to extend your knowledge of DAX and data modelling in Power BI, sign up for a for a free trial of Power BI DAX What-if Parameters by G Com Solutions.

Course Outline

Welcome

1. Welcome to Power BI DAX What-if Parameters
2. Download the course files

1. Basics of DAX What-if Parameters

1. Creating a what-if parameter
2. Implementing a what-if parameter

2. Leveraging Custom Parameter Tables

1. The solution we will be creating
2. Connecting to the data
3. Creating a date table
4. Creating a measures table
5. Creating a reference to a query
6. The Chiclet Slicer custom visual
7. The Timeline Slicer custom visual
8. Creating parameter slicers
9. Calculating the offset price
10. Ceating a dynamic title

Additional information

Users

Single User, 2 Users, 5 Users, 10 Users, 25 Users, 50 Users, 100 Users