Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating a new table in Power BI

Hi everyone,   Right now, I am working on a huge datesets. So I have different tables, but I do have a table with the most details in it, and let's call it A. Now, I have updated some new tables an...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi

     

    If possible, i would do this in database level as doing this in PBI will hit the performance when the data is huge.

     

    But, lets see if we get any other ideas in this forum.

     

    Thanks
    Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Now I have 3 tables, my goal is to get a table with all the values in it.

 

 

 

A

B

C

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

1. Table A and C should be UNIONed ( or APPENDed)  as firts step. Doing the APPEND is the easiest way, but DAX offers UNION function as well. UNION ( Table_A, Table_C). Not sure abt the performance though.

 

2. Once you are done with the UNION, Use the RELATE function to bring in 'DATE' filed from Table_B.

 

Hope this helps.

 

Thanks
Raj

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Raj,

     

    THanks for the help, yes that is what I did, I post the question to ask if there is any other ways to improve the performance, because our data is kind big and it takes hours to get the final table, and I feel like doing this could cost more time, as you have to make the relation each time. 

     

    So I am trying to use one Dax function to finish all the work or I could do it in R.

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi

       

      If possible, i would do this in database level as doing this in PBI will hit the performance when the data is huge.

       

      But, lets see if we get any other ideas in this forum.

       

      Thanks
      Raj