In this video, we discuss how to perform a scenario analysis using DAX in Power BI.
In the first part of the tutorial, we analyze how a price change affects total sales.
To do this, we'll build a supporting table with different price values, connect the table to a new sales measure and then shock the prices to see the impact on the overall sales.
Check out Centida's other videos on our website.