Forum Discussion

FelipMark's avatar
FelipMark
Icon for Helper II rankHelper II
2 years ago
Solved

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 difficul...
Need Help
Ritaf1983's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

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/1447523

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • FelipMark's avatar
    FelipMark
    Icon for Helper II rankHelper II
    2 years ago

    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