Mapping "month" to "week" data
I have a dataset with sales report by week and year (e.g., Week = 1, Year = 2022) and want to be able to append a month value so we can look and filter by MTD data. Is there a way to 'calculate' a date either through beast mode or in ETL to map the month associated with the week of the year?
