Values per weeek to month (via per day?)

[JonGunnar]

Hi, I have values per week but need them to be per month and hence correctly done for weeks that are in two different months. Is there a way to do this? Maybe going from week to day (same value for each day within a week) and then aggregate to month? Still don't know how to do this.

JG

[amitchandak · Accepted solution]

@JonGunnar , You can add week start and week end date date based on week number and year and distribute value across days. Check file for between start and end date 

Check the last question here to get week start date

https://amitchandak.medium.com/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3

week end date is +6

one more option to distribute

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...