Determine the Week of the month in Magic ETL
I'm running a sales forecast dataset and want to be able to determine what week of the month we are currently in so I can calculate the weekly sales forecast target.
Such as if the month target is 100,000 and its week 1 then the weekly target should be 25,000.
I can add a date calculation column that gives me the Week Year for the current day but I can't figure out how I can use the week year without building out an entire Week Year Calendar dataset to pull in which I'd really rather not do.
Let me know if that is my only option or if anyone has any other ideas.