DAX function to calculate actuals

[Tarek78]

Hi All,

I have a model with various tables with the main ones being:

Fact Actuals : showing the actual P&L per GL

Fact Budget 2022: showing the budgeted P&L per GL for 2022

The net revenue is GL A111 (gross revenue) - GL A115 (returns).

I would like to create a function showing the "adjusted Actuals".

Let's use an example so that you can understand:

1. The revenue budgeted is 1000 and the actual 2021 (LY) revenue is 900

2. We have budgeted some travel costs for 100 (= 100/1000 so 10% of the revenue)

3. In 2021, the travel costs were 100 (100/900= 11%)

4. In 2022, I notice that my travel cost are 200

I want to create a DAX formula to calculate an adjusted Actual 22 being:

Travel Cost 2021/ Revenue 2021*Revenue Budget 2022 > Thus way, I can easily where are the variances vs the actuals 2022

Don't know if it is clear as it is complex to explain

[Tarek78]

Up. Can someone help me 

[Tarek78]

Hi Everyone, feel free to let me know if it is not clear