Forum Discussion

mtrevisiol's avatar
mtrevisiol
Helper V
3 years ago
Solved

Add TARGET column to KPI matrix

Hi everyone.

I am creating a matrix that shows the performance of the company, month by month, using some indicators/KPIs.
In the columns there are the month and year (from January of this year to the current month), while in the rows there are the various indicators (total sales, active customers per month, ...). The format of the columns is "YYYY-MM":

 

and this is the underlying data structure:

 

 

I would like to understand how to add a 'target' column, with a single value for each indicator, containing the target value for each measure:

 

Here is the pbix file: https://www.dropbox.com/s/ipcv3ojxveqojat/Matrix%20with%20target%20values.pbix?dl=0

 

Can anyone help me? many thanks in advance.

 

7 Replies