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.
Hello,
My problem involves creating a measure/measures for forecasting within a month based on actual data. Esstensially, I am using a 60 day %GT for each day of the week, in the image below.
From that 60 day average, I need to be able to divide by the total number of the specfic day in the month, i.e. Feb 2023 has 4 Fridays, 23.66%/4=5.92% for each Friday in the month. This would then be applied to the month as a whole for each day to calculate how much of the month's potential values have been collected and forecast what could be collected in the remaining month based on the remaining percentages by day.
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |