Hello Guys, Thanks for your support. I have fixed my issue with another work around.

Hi, Thanks for the update. Can you please provide some example or more explanation. Thanks in advance.

Yes but as I already mention ago on existing measure will not give me any data because there no data set left for ago.As i already using level all_year(means all year from project started to current period) in column "PROJTD_BILLING". So AGO("PROJTD_BILLING","ALL_YEARS",1) will not result any data. Beacause PROJTD_BILLING…

Hi Gianni Thanks for the update You are correct 25 + 35 is supposed to give you 60 as to date billing for 2017-02. And I also want calculate current period billing only but not directly as you mention. (TODATE of 2017-01) - (TODATE of 2017-02) = (value of 2017-02) * -1 I want it from already calculate column…

Thanks for your time. But in my case ALL_YEARS means all year not a particular year. And whenever I want to use ago function with above already created measure "PROJTD_BILLING" (calculated for all_year),it will not left with any dataset. Hope I am clear!!!. Regards, Parag

Hello Robert, Thanks for the update but I kind use ago function on my existing measure PROJTD_BILLING, the reason is in PROJTD_BILLING I am passing "ALL_YEAR" level, so it will include all data set. So when i am using ago with same level there is no data set that wil not return any value. And i cant use ago with different…