Forum Discussion
Filter by Year into a Date Field
Hi Everybody, I'm trying to build a measure which filters out values based on a year and retrieve the previous year. For example, if it's 2017, retrieve all 2016 fields. The problem I believe is wit...
TomMartens
Super User
Super UserHey,
I would just build a separate Calendar table, join the date column from this table with your table, so that do not have to consider the year column in your booking com.
Then it will become much more simpler to build your previous year measures. Maybe this gets you started:
http://www.daxpatterns.com/time-patterns/
Hope this helps
I do have a calendar table and there is a relationship between that table and my Booking table, though not to that fields mentioned in my post. If I were to add a relationship between from calendar table to my year, and/or date field, what would this measure then look like?