Forum Discussion
Daily sales project
I'm doing a project where I want to project daily sales until the end of the month, based on sales made to date.
Basically a sales trend for the end of the current month, but I'm having difficulties with how to create this temporal measurement.
I already have my sales table and another calendar, the final result I want is like this:
the white line is the designed design.
An example would be: It's been 2 days and we sold 100 reais, if the month goes until the 30th we will sell 1500 reais at the end of the month. But you want this daily view.
Hi FelipMark
If I understood you correctly and the question is about forecasts, please take a look at the linked tutorials:https://www.youtube.com/watch?v=_TAGpAJ9rTQ
https://www.youtube.com/watch?v=U7sl7guoxMI
if it is something else
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
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/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
2 Replies
- Ritaf1983
Super User
Hi FelipMark
If I understood you correctly and the question is about forecasts, please take a look at the linked tutorials:https://www.youtube.com/watch?v=_TAGpAJ9rTQ
https://www.youtube.com/watch?v=U7sl7guoxMI
if it is something else
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
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/1447523If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
- FelipMark
Helper II
I can't upload a file here...
But in the video you sent, the sales forecast is based on the previous year, I want to do it based on the month's revenue. I have the current month's sales trend with the following measure:Tendence = VAR vAverage = DIVIDE([Sales], [# days occurred]) RETURN CALCULATE( vAverage*[# Days])
but it only returns the total month, not per day