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
mrslyfox's avatar
mrslyfox
Helper II
9 years ago

Measure:= SUMX(RELATEDTABLE(F_Inventory),F_Inventory[M2])
/
(CALCULATE(
                        IF(
                            COUNT(D_Date[DATE_Date])>=30,
                            SUM(F_Invoice[M2])
                           ),
                        FILTER(
                                    ALL(D_Date),
                                    D_Date[DATE_Date]>(MAX(D_Date[DATE_Date])-30)
                                          && D_Date[DATE_Date]<=MAX(D_Date[DATE_Date])
                            )
)/30)

MFelix's avatar
MFelix
Super User
9 years ago

With only the formula of this meaasure and not knowing what each value represents I can't do a lot but I notice that in the IF you do a Count of the DATE why are you using a count and not the actual date itself?