The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello!
I hope someone can help me find out how to fix the issue below:
I need to calculate the forecast accuracy by different levels so I created sumamry tables by category, channel and month.
The foreacst accuracy is calculated using the absolute error which is calculated at the lowest level, market-channel-product.
Actuals= Sales
Abs error= abs(actuals-forecast)
Forecast Accuracy= 1-(abs error/actuals)
PBI (also refer to screenshot)
This screenshot shows the summary tables and the calculation in PBI, then table sin the middle are the same summary tables but I summed up the columns and calculated the forecast accuracy to validate the data.
Tables on the right are summary tables from excel, which is what need power BI to do (data is not the same, is just the calculation example).
DAX formulas:
Solved! Go to Solution.
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...