Power BI DAX What-if Parameters
3.5 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,716 students enrolled

Power BI DAX What-if Parameters

DAX expertise: using DAX What-if parameters to let your audience customize your solutions
3.5 (3 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
4,717 students enrolled
Created by Grant Gamble
Last updated 6/2020
English
English [Auto]
Current price: $38.99 Original price: $59.99 Discount: 35% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1 hour on-demand video
  • 2 articles
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to use Power BI What-if Parameters to allow the user to customize the results produced by key metrics.
Requirements
  • Knowledge of the basics of Power BI Desktop
Description

Power BI DAX What-if Parameters by G Com Solutions is a short course which focuses on the use of DAX measures and 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 DAX 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 Power BI What-if Parameters by G Com Solutions.

Who this course is for:
  • Existing users of Power BI looking to extend their knowledge
Course content
Expand all 15 lectures 01:12:56
+ 2. Leveraging Custom Parameter Tables
10 lectures 58:58
3. Creating a date table
06:45
4. Creating a measures table
02:46
5. Creating a reference to a query
03:40
6. The Chiclet Slicer custom visual
08:43
7. The Timeline Slicer custom visual
02:52
8. Creating parameter slicers
04:21
9. Calculating the offset price
08:05
10. Ceating a dynamic title
11:42