- Open a Power BI Desktop model locally, and from the Modeling tab of the Report View, click on New Table.
- Use the DATATABLE() DAX function to create a calculated table with the scenario name, scenario value, and a sort key:
Plan Scenarios = DATATABLE("Plan Scenario",STRING, "Var to Plan",DOUBLE, "Scenario Sort",INTEGER, {{"Plan",1,3},{"10% Above Plan",1.1,2},{"20% Above Plan",1.2,1}, {"10% Below Plan",.9,4}, {"20% Below Plan",.8,5}})
Ideally, the new scenario table can be persisted within a data warehouse and the Power BI solution can be resilient to changes in scenario names and values. Per other recipes, using DAX to create tables or columns should generally be thought of as a secondary and temporary option, ...
