Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
78 | |
72 | |
65 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |