What if parameters are a vital part of starting to build forecasting scenarios. In many ways the best way to think of what if parameters is as disconnected tables, the main difference is that while disconnected tables are typically just a few values (typically ten or less), What if parameters may have 100’s. They are a series of numbers, these can then be used to manipulate values. Using multiple scenarios you can begin to run scenarios around what would have happened if… What if becomes clear now.
Case statements are used in a number of languages to stop you having to use nested if statements which are invariably complex and inefficient. SWITCH ( ) is the Case statement of Power BI.
Switch ( < expression > , < value > , < result> , … , < else > )