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.

mohammedadnant's avatar
mohammedadnant
Impactful Individual
5 years ago

Hi Anonymous 

 

Good day,

 

Try adding a new calcualted column which gives you only Month & Year

MonthYear = Format(column1, "MMM-yyyy")

 

Now you can display the result by Month, hope this helps.

 

Thanks & Regards,

Mohammed Adnan

https://www.youtube.com/c/taik18

Learn about Power BI