CY LY CALCULATIONS I HAVE DIMENSIONS FOR THE BELOW MENTIONED FIELDS I WANT CREATE A CY LY CALCULATIONS FOR ALL OF THEM I CREATED : IF [Date Parameter] = DATEADD('year',-1,[Date Parameter]) THEN 'LY' ELSE 'CY' END

You're very welcome @Ritik Singh​. Please do pop back and let us know if it solved your problem! You can select an answer as best to close off the thread (it will also help people searching for similar solutions in the future). And you can upvote helpful responses. Ta, Steve.