Daily sales project

[FelipMark]

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.

[Ritaf1983 · Accepted solution]

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]

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