Forum Discussion
Helper IIDaily sales project
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.
Super UserHi 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.
Helper III 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