How to set current year

Praveen · February 3, 2023, 6:29am

Hi

How to set formula for current year in Quicksight calculated filed

Example : I need to get months from Jan to dec of 2022 like jan 2022,feb 2022…dec 2022 on
X axis

Help me out on this

Max · February 3, 2023, 5:39pm

Do you want a filter? You can use the relative dates filter

Steph · February 6, 2023, 10:02am

If you want to build a date string, you could use the Extract function to get the month or year portion of a date.

Please let us know if either my or Max’s solution are what you are looking for.