Forum Discussion
How to maintain KPI Target in Power BI
Hi, I started with Power BI last year so my target table has only 1 year of target data for each country as shown below. This year I need to add target data for year 2023. Same as year 2022, it ...
Anonymous,
You can add a date column to the Target table and create a relationship to the calendar table using the date column. This date column will contain the first day of the year:
2022 --> 2022-01-01
2023 --> 2023-01-01
I managed to make the solution suggested by DataInsights work for my card visual by adding ALLEXCEPT to the calculate measure used in the visual which is as follows:
CALCULATE(SUM('3_INV Target'[INV Target]), ALLEXCEPT('2_Calendar', '2_Calendar'[Year]))
I will just input my yearly target value on 1st day of every year and do not have to replicate for every month throughout the year. Thank you for the solution.