Forum Discussion

epaez's avatar
epaez
New Member
5 years ago
Solved

Forecast accuracy

Hello Community, thank you. I have a linear series of product sales, month to month from the years 2015 to 2019, by product, customer I'm using the Power BI Analitycs Forecast option to add the 202...
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi epaez ,

    Basically you can export data from your line chart visual which includes forecast value like in 2019, here are the steps that you can try:

    1. Export data in the line chart including 2019 forecast as a .csv file

    2. Import the .csv file and transform data like only keep the date 2019 and the forecast value column in power query, close and apply it.

    3. Create a relationship between the new table and the initial table based on the date field.

    4. Create a measure to calculate the accuracy

    Forecast accuracy = 
DIVIDE(SELECTEDVALUE('Sales Table'[Product sales]), SELECTEDVALUE('Forecast sales by 2019'[forecastValue]))​

    5. Use a table visual to show the comparison

    Attached a sample file in the below, hopes to help you.

     

    Best Regards,
    Yingjie Li

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

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi epaez ,

Basically you can export data from your line chart visual which includes forecast value like in 2019, here are the steps that you can try:

1. Export data in the line chart including 2019 forecast as a .csv file

2. Import the .csv file and transform data like only keep the date 2019 and the forecast value column in power query, close and apply it.

3. Create a relationship between the new table and the initial table based on the date field.

4. Create a measure to calculate the accuracy

Forecast accuracy = 
DIVIDE(SELECTEDVALUE('Sales Table'[Product sales]), SELECTEDVALUE('Forecast sales by 2019'[forecastValue]))​

5. Use a table visual to show the comparison

Attached a sample file in the below, hopes to help you.

 

Best Regards,
Yingjie Li

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