Forum Discussion
Two Fact Tables Nightmare
I'll be refreshing this page every minute in hopes that a Power BI Guru can save my project. I was given a Historical-Current Fact Table, we will call this TABLE 1, where they wanted a plethera ...
O you have the same number of columns in each fact tables ? Because with Union it is a must have
Yes I created extra columns in the forecast table to achieve the union. However, when it comes to combining historical measures with forecasted measures, it produced totals for each row - like the picture showing 170 for each row.