Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is probably a fairly straightforward question, but are forecast time periods inclusive of the final period?
For example, right now I'm trying to do a forecast of sales through the end of the month. It's 12/6/2016, so I set the forecast length to 26 days. Does the forecast include all revenue gained on 12/31/2016 or does it stop at 11:59p 12/30?
Hi @sbstern,
I'm not so clear which period function you used, can you provide some detail information about this?
In addition, you can try to use the below formula to select the specified date range.
AND([Date]>=(Date(Year(Current Date),Month(Current Date),1) + TIME(0,0,0),[Date]<Date(Year(Current Date),Month(Current Date)+1,1)+ TIME(0,0,0))
Regards,
Xiaoxin Sheng
Thanks, that's a good formula but I'm not actually using any period function. I'm using the forecast tool in the analytics tab for line graphs in PowerBI. You set Forecast Length for X points/seconds/minutes/hours/days/months/quarters/years.
My question is whether the final day is inclusive. If I set a 15-day forecast on November 15, does that run until 12:00am on November 30 or 11:59pm on November 30?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |