Measurement to sum Actua Effort for yeach years starting from Current_Date
Dears,
i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years:
- Sum of Actual effort when Year(Completion Date) = Year(Current Date)
- Sum of Actual effort when Year(Completion Date) = Year(Current Date)-1
- Sum of Actual effort when Year(Completion Date) = Year(Current Date)-2
This is the acual formula:
FILTER(SUM("Completion Information"."Total Actual Effort") USING (YEAR("Post-Active Details"."Completion Date") = YEAR(CURRENT_DATE)-1))
The sum is working but it's actually summing all actual efforts, and it's not summing based on YEAR("Post-Active Details"."Completion Date") = YEAR(CURRENT_DATE)-1.
Tagged:
1