Forum Discussion
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...
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
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
Hi,
Measure used for different indicators and tables at the same repot page.I do not see it possible at the moment.
I can't help you without further information can you please show some data or the way you calculate the Measure?
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)
