PASTYEAR function issue with leap years | Product Feedback Forum

Luke Flett · 2025-07-03T23:08:17.103000Z

Hello Sisense Team,I encountered an issue while using the PASTYEAR function in a column chart with date/month as a category. Specifically, I noticed that there is no data displayed for February 29th from last year. I assume this is because the current year isn't a leap year. Could you please advise on how to resolve this issue?I'm looking to return the current year's values split by months, alongside last year's values. Last year's values should display regardless of whether or not i have a value this year. Any guidance or solutions would be greatly appreciated!Thank you.

MoreDiscussions

PASTYEAR function issue with leap years | Product Feedback Forum | Sisense Community