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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

i just want to aggregate this weekly data into monthly. For instance 1967-01-01 and the aggregate of four week and 1967-02-01 and then the aggregate of its four weeks. 

 

v-jingzhang's avatar
v-jingzhang
Community Support
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.