How to replicate this expression in QLik sense

[vinayk1]

DATEADD('year',-1,[Month])

here [Month] field has date values.

this essentially to get fiscal year as a dimension where year starts from April month.

[MayilVahanan]

Hi

Try like below

=AddYears(Month,-1)