finance variance data query

Question

Hi Team

I have the below scenario for my finance data, where i want to calculate the variance and % variance between Actual, Forecast, and Budget. As i have flat filed the data these three are in the same field called Scenario and the Values in $$ are in the Values field. Just showing below, how these values will be displayed/used, which will be across Income and Expense line items.

Please suggest how i can calculate these as they are in the same field i am unable to do calculations. New to DAX so apology if this is an easy one

Data Layout Calculation 1
Scenario Values Actual Budget Variance
Actual $$ Income $ $ = Actual less Budget
Budget $$ Expenses $ $ = Actual less Budget
Forecast $$
Calculation 2
Actual Forecast Variance
Income $ $ = Actual less Forecast
Expenses $ $ = Actual less Forecast

Answer 1

Hi @Nishesh Ved ,

Hope you are doing well ,

In order to Address DAX related queries , it's suggested that you could post your case in dedicated forum to get professional advice.

Hope this helps.
If the answer is helpful, please click Accept Answer and kindly Upvote it. If you have any further questions about this answer, please click Comment.