Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to aggregate weekly data into monthly

Hello, I have two data sources, one is monthly and the other is weekly. I want to aggregate teh weekly one into monthly. Can anyone help me achieve that. Thanks
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

    Add a calculated column like below to get the first date of each month and change its data type to Date.

    StartOfMonth = EOMONTH([Date],-1)+1

    Kindly let me know if this helps.
    Community Support Team _ Jing Zhang
    If this post helps, please consider Accept it as the solution to help other members find it.

richbenmintz's avatar
richbenmintz
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Hi Anonymous ,

 

Do you have a date table that define a 4-4-5, style calendar? If not then weeks will span months? I guess you can use a date dimension that defines all the sttributes of the date that you need and join that to your fact

 

Make Sense