Power BI has two types of parameters: Power Query and What if parameters. In this video, I will explain a very useful use case of the what-if parameters, and if you haven't ever worked with it, it is a great way to understand what-if parameters are and what you can do with them. The What If parameters are also called informally as DAX parameters.
find the codes from my blog article here:
radacad.com/power-bi-what-if-parameter-for-getting-the-sales-of-x-months-ago-use-case-scenario
- Power BI DAX What If Parameter to make calculations dynamic ( Download)
- WHAT-IF PARAMETER in Power BI Desktop [Dynamic Measures] ( Download)
- How to start using WHAT-IF Parameters with your Power BI Reports // Beginners Guide to Power BI ( Download)
- Can What If parameters help in Power BI reports ( Download)
- Dynamic calculated Columns and Measures based on Filter Selections Variables ( Download)
- DAX for Power BI - Dynamic % Change ( Download)
- Measures vs. calculated columns in DAX and Power BI ( Download)
- Using the SELECTEDVALUE function in DAX ( Download)
- Digging into DYNAMIC format strings for DAX Measures in Power BI ( Download)
- Change Measure using a Slicer ( Download)
- DAX for Enviro's: Dynamically analyse water security outlooks using What If parameters in Power BI ( Download)
- Can you use Power Query Dynamic M Parameters for multi-select ( Download)
- 3 Ways to use Calculation Groups You Need to Know ( Download)
- Dynamic Tables in Power BI - field parameters with conditional formatting! ( Download)
- Computing totals by summing visible values in DAX ( Download)