Mapping "month" to "week" data

merylmccurry
merylmccurry Member
in Beast Mode

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?

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    There isn't a simple way to do this as a week of the year can straddle two different months so you wouldn't be precise with the months when you calculate it this way. How would you want the monthly amounts to be calculated? Based on the start of the week or the end of the week? You wouldn't be able to get precise monthly numbers.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    There isn't a simple way to do this as a week of the year can straddle two different months so you wouldn't be precise with the months when you calculate it this way. How would you want the monthly amounts to be calculated? Based on the start of the week or the end of the week? You wouldn't be able to get precise monthly numbers.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**
  • merylmccurry
    merylmccurry Member

    Got it - that makes sense, thanks!

Categories