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

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
9 years ago

If my understanding is correct, if involves some steps, so I made a comfortable function for it here: http://wp.me/p6lgsG-sN