Forum Discussion
Splitting Weeks and data
I have a query with about 10 columns of descriptors and a few thousand rows of data. The excel file I am using is for forecasting and lists dates in the format "Jan19 to Jan19" etc. The edit...
using the DAX WeekNum(date) -- the weeks are right (starting on Sunday) .. not sure how you converted them
Sorry, I should've mentioned that the only dates are the first of every month. The only weeks that formula gives me are 1, 5, 9, . . . etc.
So I need to somehow get continuos weeks (1-52) and divide the values by 4 or 5 (depending on the month) to get the averages for each week in the respective months