finance variance data query

Nishesh Ved 6 Reputation points
2022-08-18T09:31:46.797+00:00

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

232351-data-view.jpg

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,485 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. RajeshKumarMSFT 1,971 Reputation points Microsoft Vendor
    2022-08-23T10:01:25.563+00:00

    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.

    0 comments No comments