Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |