Table with Budget, Current and Variance over different periods

Question

Hi, Hope someone can help (or just tell me not possible!).

I am trying to build a table where I have 5 years of Budget, 5 years of current view and finally the variance - something like the below (quick example from Excel):

I am failing with tables, and not sure how to approach? Measures or tables side by side?

Thanks for any help or hints

mickey64 · Accepted Answer

For your reference.
&nbsp;
Step 0: I use a DATA table below.
&nbsp;
Project Category Year ValueProject 1 Budget Risk 84%Project 1 Budget 2025 953Project 1 Budget 2026 1179Project 1 Budget 2027 1059Project 1 Budget 2028 869Project 1 Budget Total 4060Project 1 Current View Risk 28%Project 1 Current View 2025 1061Project 1 Current View 2026 1138Project 1 Current View 2027 765Project 1 Current View 2028 809Project 1 Current View Total 3773Project 1 Change Risk -56.20%Project 1 Change 2025 108Project 1 Change 2026 -41Project 1 Change 2027 -294Project 1 Change 2028 -60Project 1 Change Total -287Project 2 Budget Risk 57%Project 2 Budget 2025 1080Project 2 Budget 2026 795Project 2 Budget 2027 918Project 2 Budget 2028 931Project 2 Budget Total 3724Project 2 Current View Risk 20%Project 2 Current View 2025 1026Project 2 Current View 2026 933Project 2 Current View 2027 770Project 2 Current View 2028 1056Project 2 Current View Total 3785Project 2 Change Risk -36.90%Project 2 Change 2025 -54Project 2 Change 2026 138Project 2 Change 2027 -148Project 2 Change 2028 125Project 2 Change Total 61Project 3 Budget Risk 35%Project 3 Budget 2025 873Project 3 Budget 2026 932Project 3 Budget 2027 871Project 3 Budget 2028 892Project 3 Budget Total 3568Project 3 Current View Risk 57%Project 3 Current View 2025 829Project 3 Current View 2026 925Project 3 Current View 2027 956Project 3 Current View 2028 965Project 3 Current View Total 3675Project 3 Change Risk 22.30%Project 3 Change 2025 -44Project 3 Change 2026 -7Project 3 Change 2027 85Project 3 Change 2028 73Project 3 Change Total 107
&nbsp;
Step 1: I make a matrix below.

&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Table with Budget, Current and Variance over different periods

2 Replies

Related content

Budget, actual and variance matrix

PBIGenie Hammerhead Variance Bar – Actual vs Budget Layout in Power BI

Modern Baseline Variance Layout for Actual vs Budget

Actual vs Forecast vs Budget Variance

Working with Budgets