Forum Discussion
Creating a new table in Power BI
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
Are you trying to do Merge functionality or APPEND functionality in DAX?
If MERGE, how many columns you want to bring from Table 2 to Table A?
Thansk
Raj
Sorry , I add duplicated photos, but you can figure out which one, and the idea is there
Now I have 3 tables, my goal is to get a table with all the values in it.
A
B
C
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
RajHi 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