Analytic tab for Line Grpahs can add a forecast line which is based on pretty solid statistical calculations, saving a lot of R scripting. The added forecast line can be seen on the graph. I want to access those value in DAX formulas to calculate measures like: Year to date variance from the forecast values, accuracy of the forecast etc. Here are the details: Create a visual i.e. line graph and add a forecast line using Analytics Tab. To test the accuracy, use hindsight by ignoring last X points and forecasting for X points. The actual and forecast lines are shown on visual. Click on 'see data' from the top right corner of the visual and it shows the columns for Actual Values and forecastValue (of course, the forecast calculated by Power BI). Being able to access the forecastValue column in DAX formulas would open up a whole range of possibilities.
3 Comments
- rquintino
Advocate II
voted, this would be useful, power bi built-in forecast model really under explored, allowing only for visual forecasting similar idea, but now for Power Query/M https://ideas.powerbi.com/ideas/idea/?ideaid=0cac7df0-9ad5-ea11-bf21-281878bd6a00 - Ragav_SrinivasaNew Member
100% need this! Will be a huge time saver.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Allow Mirror Database to use Variable Library, not just Deployment Rules
Currently, the source connection for Mirrored DBs is managed through Deployment Rules in data pipelines. There is no way to use Variable Libraries with Mirrored DB, like you can do in CopyJob or Dat...hedeencharles36 minutes agoAdvocate INew423Views11likes1CommentAzure Maps Power BI - Support Dynamic Geometry Data from Dataset Columns
Problem The Azure Maps Reference Layer currently relies on file uploads or URL-based geometry sources (GeoJSON, KML, etc.). In our enterprise use case, geometry data is private, changes daily, and m...jurner2 hours agoNew MemberNew22Views1like0CommentsDynamic Subscription Schedule After Data Refresh
There is currently no option on schedules for dynamic subscriptions of reports to schedule it to run after a semantic models data refresh (once daily), like can be done with standard subscriptions. ...MartynR4 hours agoRegular VisitorNew5Views0likes0Comments