Forum Discussion
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
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)+1Kindly 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.
4 Replies
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
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
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)+1Kindly 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.
