Forum Discussion
How to link SOURCE field from 2 table ?
Hi All
I need some help one link these 2 table by SOURCE field :-
Above is my PBI file :-
Paul
Hi,
Append Sales and AR Table into a new table and remove all columns other than SOURCE. Change the case to Upper case of this column and remove Duplicates from this column. Now build a relationship from the SOURCE columns of both tables to the Source column of the new table you created.
As mentioned in my previous message, Append both tables in power query.
3 Replies
- Ashish_Mathur
Super User
Hi,
Append Sales and AR Table into a new table and remove all columns other than SOURCE. Change the case to Upper case of this column and remove Duplicates from this column. Now build a relationship from the SOURCE columns of both tables to the Source column of the new table you created.
Hi Ash
Thank you for your sharing , i have data model with out target table , i have link all SOURCE table it work fine :-
In the past i have target table , for this i dont have target table , So i don't know how to create a SOURCE link table :-
Source = DISTINCT(UNION(all(SALES[SOURCE]), all(TARGET_[SOURCE])))The above script if i change to :-
Source = DISTINCT(UNION(all(SALES[SOURCE])))it does not work.
- Ashish_Mathur
As mentioned in my previous message, Append both tables in power query.