Forum Discussion
pratafran
Helper III
Helper IIIBuild a visual showing evolution of a parameter based on two databases with different periods oftime
Hi!, I think it is a very simple question but I guess if there is a simpler approach to sort this out than the one I'm thinking in. I have two databases in my Power Bi model. 1 - A plain databas...
parry2k
Super User
Super Userpratafran you can append the tables in power query and that is the best approach and best practice.
pratafranparry2k thanks for your answer. That was what I was thinking but with that approach I would be duplicating a lot of information.
So, it is not possible to add the volumes of both databases to the same visual to show them as a continuos line?
- parry2k
pratafran not sure if appending will make it duplicte information. You just not load other two tables in model, just load the one whihc is combined, so I don't see there will be anything duplicated.
- pratafran
I finally achieved the objective by appending the two tables. It is adding more refresh time to do this task but at least it worked.