Forum Discussion
Linking and Filtering Questions
I'm trying to do something that would seem to be fairly easy. I want to report/analyze on a monthly basis how my forecasted and actual costs change each month of the fiscal year. I have three...
Sounds like you need to Append the 3 Queries into 1.
Make sure you uncheck Enable Load for each Query.
Then Append all 3 into a new one and load only that one into the Model.
Look at my response here http://community.powerbi.com/t5/Desktop/Append-query-duplicating-Current-Table/m-p/27367#M8898
You may need to add a Unique identifier column for each table... Before appending
Make sure you uncheck Enable Load for each Query.
Then Append all 3 into a new one and load only that one into the Model.
Look at my response here http://community.powerbi.com/t5/Desktop/Append-query-duplicating-Current-Table/m-p/27367#M8898
You may need to add a Unique identifier column for each table... Before appending
Sean is spot on (as usual!). If you have three tables that are close to the same, it makes more sense to turn them into one. Use you bridge table to populate the rows but pull the facts from the big appended table.
I made some clumsy (new user) attempts to do that, but let metry again. Thanks for the help.
