Forum Discussion
Helper IData Blending in Power BI
Hi,
I would also suggest the approach that Phil proposes: merging the tables with Power Query it's an "Append" operation likely pretty much the same as Tableau does it. I don't see why values would be duplicated? I assume if you have values for the same dates and attributes in the different tables they need to be aggregated in some way?
Martin
Take you Power BI project to the next level --> http://Powerbiexperts.com.au
Helper IHi!
If I do what Phil says I will end having a table with duplicated values in the columns right? I dont want that.
What Imkef says is the approach I stated in my first message. It would be ok if the complexity wouldn't be so high. Apart form making the join there is the point of generating this aux table.
In this case is worse as the dates are updated each day so you would need to create a table from a complex formula so that you always have new days and so on. Not e avery quick/easy approach.
Thanks,
Kudo KingpinHi,
I would also suggest the approach that Phil proposes: merging the tables with Power Query it's an "Append" operation likely pretty much the same as Tableau does it. I don't see why values would be duplicated? I assume if you have values for the same dates and attributes in the different tables they need to be aggregated in some way?
Martin
Take you Power BI project to the next level --> http://Powerbiexperts.com.au
- ImkeF
Community Champion
If my understanding is correct, if involves some steps, so I made a comfortable function for it here: http://wp.me/p6lgsG-sN
- psikonetik
This solved the issue!
Merging the tables created duplicates, however after changing the names of the columns in the tables so that they match in all the columns but the ones that I want to graph, and using append solved perfectly the issue.
Thanks!
