Forum Discussion
formulas between different tables
Hello mat007mat
as you are writing about KPI I assume you need a solution in Power Pivot/DAX. I would prefer combining such tables in Power query and do the final calculation in DAX.
However.. to solve this with DAX I saw no other solution to create a new table out of the forecast-table only using country, type and month. Then adding 3 new columns to calculate forecast, sales and error. the measure uses then sales and error to get the KPI.
Find enclosed the file with my solution
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hello mat007mat
as you are writing about KPI I assume you need a solution in Power Pivot/DAX. I would prefer combining such tables in Power query and do the final calculation in DAX.
However.. to solve this with DAX I saw no other solution to create a new table out of the forecast-table only using country, type and month. Then adding 3 new columns to calculate forecast, sales and error. the measure uses then sales and error to get the KPI.
Find enclosed the file with my solution
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
This is great! thanks a lot for your time and effort in this!
I have not build it in my tool yet - but I am sure that the described methodology will do.
formulas that I was not aware of, but that are really helpfull are:
* summarizecolumns() - great for combining tables
* sumx() with the described filtering - this helps a lot to do the required calc
thanks again for your input, and happy new year!