How to calculate YTD for current Year and YTD Month Ago for Current Year

User_F4K7G

Hello,

I am showing Year, Month and Customer Counts in report. My requirement is to calculate Current year YTD and Current YTD Month Ago and get the difference or growth on these measures. So I am using

TODATE(Customer Counts, Dimension Date.Dim Date.Year)

for current YTD which is giving intended results. Now I want to calculate YTD month ago for same year and I am using

AGO(TODATE(Customer Counts, Dimension Date.Dim Date.Year), Dimension Date.Dim Date.Month, 1)

which is giving error of [nQSError: 22044] Nesting of AGO or TODATE functions with differing level arguments is not supported.

How to achieve this calculation.

Help would be appreciated.

Thank you.

User_F4K7G

Hi all, I resolved it by subtracting current month from year to date which gave me required results.

Thank you.