Forum Discussion

mrslyfox's avatar
mrslyfox
Helper II
9 years ago
Solved

Target Value KPI Targets

Hello, Have a raw based table with target values for each month. Each raw has a link date for the first date of month.  My KPI should calculated for previous day of month and compared with target v...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago
    Hi mrslyfox,

    Did you try to make the calculation to the first date of the month instead of previous day?

    I have a simolar setup and transform all the daily information to the same date that compares to the one in the target table.

    Regards

    Mfelix
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi mrslyfox,

 

Can you share some sample file to test?

 

In addition, you can also try to use belwo formula if it suitable for your requirement:

 

Measure: Calculate the previous month average as target and show it at the first date of each month.

 

Target=
var currDate=Max(D_Date[DATE_Date])
var minDate=MINX(Filter(ALL(F_Invoice),Month(F_Invoice[Date])=Month(CurrDate)&&F_Invoice[Date]<=CurrDate),[Date])
var perviousTarget=AVERAGEX(Filter(ALL(F_Inventory),[Date]>=Date(Year(currDate),Month(currDate)-1,1)&&[Date]<=Date(Year(currDate),Month(currDate),1-1)),[M2])
return
IF(MAX(F_Invoice[Date])=minDate,perviousTarget,blank())

 

 

Regards,

Xiaoxin Sheng

  • mrslyfox's avatar
    mrslyfox
    Helper II
    9 years ago

    Hello,

    Targets comes from SQL table as is.

    One month = one raw devided by columns with different goals values.

    Link date field looks like dd-mm-yyyy where day always equal to firtst day of the month.

     

    My KPI is calsulated per day of month.

    It mean I need some how to say that IF KPI is calculated for current date, the target value should be picked up for the first date of month or just like a sum for current month (because only one target record exist).

    • mrslyfox's avatar
      mrslyfox
      Helper II
      9 years ago

      Why the KPI goal target value is not calculated in the same way as

      the same formula showing right result for Card visual..