Forum Discussion

pratafran's avatar
pratafran
Icon for Helper III rankHelper III
7 years ago
Solved

Build 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...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    pratafran you can append the tables in power query and that is the best approach and best practice. 

pratafran's avatar
pratafran
Icon for Helper III rankHelper III
7 years ago

parry2k 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's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

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's avatar
    pratafran
    Icon for Helper III rankHelper III
    7 years ago

    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.