There is a report that is currently in Excel but I’d like to move it to Power BI:

• 2023 Actual = Actual sales 2023
• 2024 Actuals = Actual sales 2024
• 2024 Target = Sales Targets 2024
• Variance to Target = 2024 Actuals – 2024 Target
• Working Days = working days per month
• Avg Daily Sales = Avg Sales per Working Day

Report is refreshed daily meaning that current month would always have fresh sales.
The idea is to have up-to-date 2024 Sales Actuals in order to estimate FY forecast based on YTD actual performance. Targets are static throughout the year.

Here is the data model that I have:

• Dim_Date = Common Date table between Fact_Sales and Sales Targets

Can you please suggest the best way to accomodate the above-mentioned table in Power BI?

I tried creating measures in Power BI but the results are unsatisfactory: blanks for 2023, unable to add Variance:

I was thinking to create a calculated table but I believe calculating differences would be tricky. Looking for support from the community of experts.

Thank you!