Forum Discussion
Help with Power BI Metrics
Only Growth % should be shown in year where prvs year is available in this case 2023 wouldn't have any comparisons, similarly for forecast which will only be shown in future years 2025, 2026 not in ...
| City | Year | Operating Expense | Actual Sales | Plan Sales |
| A | 2023 | 259 | 702 | 609 |
| A | 2024 | 288 | 735 | 604 |
| A | 2025 | 233 | 587 | 607 |
| A | 2026 | 212 | 688 | 597 |
| A | 2023 | 201 | 645 | 729 |
| A | 2024 | 224 | 711 | 652 |
| A | 2025 | 319 | 594 | 652 |
| A | 2026 | 285 | 679 | 631 |
| A | 2023 | 256 | 664 | 550 |
| A | 2024 | 286 | 592 | 589 |
| A | 2025 | 208 | 597 | 570 |
| A | 2026 | 330 | 595 | 563 |
| A | 2023 | 269 | 643 | 716 |
| A | 2024 | 200 | 659 | 614 |
| A | 2025 | 281 | 736 | 574 |
| A | 2026 | 235 | 576 | 704 |
| B | 2023 | 224 | 626 | 691 |
| B | 2024 | 224 | 636 | 741 |
| B | 2025 | 267 | 717 | 625 |
| B | 2026 | 326 | 699 | 636 |
| B | 2023 | 260 | 733 | 680 |
| B | 2024 | 280 | 661 | 743 |
| B | 2025 | 201 | 669 | 555 |
| B | 2026 | 292 | 721 | 554 |
| B | 2023 | 221 | 562 | 611 |
| B | 2024 | 250 | 640 | 736 |
| B | 2025 | 293 | 660 | 630 |
| B | 2026 | 302 | 730 | 587 |
| B | 2023 | 221 | 555 | 565 |
| B | 2024 | 244 | 587 | 612 |
| B | 2025 | 322 | 641 | 693 |
| B | 2026 | 238 | 641 | 552 |
Hi ,
Will this work