Forum Discussion

psikonetik's avatar
psikonetik
Icon for Helper I rankHelper I
9 years ago
Solved

Data Blending in Power BI

Hi,   Is there a way to do data Blending in power BI in a similar way Tableau does? Lest say I have one table with multiple rows for each date and another one with the same situation. I want to put...
Need Help
  • karaoan's avatar
    karaoan
    9 years ago

    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

karaoan's avatar
karaoan
Icon for Kudo Kingpin rankKudo Kingpin
9 years ago

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

psikonetik's avatar
psikonetik
Icon for Helper I rankHelper I
9 years ago

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!