Hello: I would like to use a date column from my fact table to filter my data without using DAX and YTD functions if possible.
I woul like to filter all records in the current year of the Policy Date column. The Is in the last 1 Years option gives me the last 52 weeks over the course of 2022 and 2023.
The in the last 1 calendar years option gives me the entirety of 2022.
I can accomplish my requirement by filtering anyting after 1/1/23, but that will require someone to change that filter when the calendar turns again.
Business Intelligence Analyst
Amwins Insurance Group