PeriodFilterTable PriorYear

[MODUser]

Found a PeriodFilterTable to which I needed to add Prior Year. Added code is giving me the full prior year and the first day of the current year...I need only the prior year dates to output. Please advise. 

[lbendlin · Accepted solution]

Before the last comma insert  "-1"

[MODUser]

That's what I had tried, but didn't work...then I realized, after recieving your response that TodaysDate was not just a date, but a datetime zone so I used...

{"Prior Year",
Date.AddYears(Date.StartOfYear(TodaysDate),-1),
Date.StartOfYear(TodaysDate) - #duration(0,0,1,0),
8}

And that worked.