Modifying the eazyBi calculated field to be based on the Quarter end date

[Mohamed El Taweel]

Hi,

For every milestone (ticket), we calculate the KPI calculated field as following

CASE WHEN [Measures].[Average resolution days] <= 30 THEN 10
  ELSE CASE WHEN [Measures].[Average resolution days] > 30
       and [Measures].[Average resolution days] <= 50 THEN 8
       ELSE CASE WHEN [Measures].[Average resolution days] > 50 THEN 7
       END
  END
END


There is a business need to Instead of the Measures].[Average resolution days], to replace it with
(Quarter end date  + 10  working days  -  Submission date) , How can I do this ?

Thanks