Sensitivity table in power bi

Lucia Uda 1 Reputation point
2022-11-11T13:11:25.32+00:00

Hi, I am trying to replicate excel´s sensitibity analysis in power BI.

My idea is to reach this output, where I have two variables (selling and buying price) and the different results inside the table.

259554-image.png

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,707 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,630 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,917 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Limitless Technology 44,101 Reputation points
    2022-11-16T15:10:51.877+00:00

    Hello there,

    Power BI facilitates a fantastic scenario analysis technique which is used to determine how an actual or projected measure is affected by changes in the assumptions upon which that measure is calculated. This business technique is called as Sensitivity Analysis as well.

    You can find more info from here https:// community.powerbi.com/t5/Desktop/What-if-Analysis-in-Power-BI-Multi-layered-Scenario-Building/m-p/941324#:~:text=Power%20BI%20facilitates%20a%20fantastic,as%20Sensitivity%20Analysis%20as%20well.

    Create measures for data analysis in Power BI Desktop https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-measures

    Hope this resolves your Query !!

    --If the reply is helpful, please Upvote and Accept it as an answer–