Forum Discussion

jessicarocha's avatar
jessicarocha
Helper IV
4 years ago

Calculate Mean Absolute Error using columns from 4 tables

Hi guys,   I've been trying to calculate the MAE but I am having some problems. I think the solution could have something to do with the summarize function but I am not sure how to use it here.   ...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

jessicarocha maybe add a different column first and then sum it up:

 

Difference Column = Table[History] - Table[Forecast]

Difference Measure = SUM ( Table[Difference Column] )

Avg = DIVIDE ( [Difference Measure], COUNTROWS ( Table ) )

 

✨ Follow us on LinkedIn

 

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

jessicarocha's avatar
jessicarocha
Helper IV
4 years ago

Thanks for the answer parry2k. How can I create this column since the two variables are in different tables?
I thought about a calculated column but it is not working. My two variables are in different fact tables that are not direct connected to each other. But they could be connected using the Dim Subsidiary and Dim Date....

Thanks. 

Greetings, Jéssica