Forum Discussion
Data modeling and relationships
Hi guys,
I am a newbie. I am really confused with data modeling to fix my relationships:
I want to combine two columns from different tables to each other. Both columns are a loannumber (Customer ID) column.
1: I dont understand whether to fix this data modeling (Star schema) with DAX or Power Query Editor.
2: Can I use Merge Queries to subset the two columns together or must I really do it with DAX?
3: If I do it with DAX, what code must I use (for example using UNION with Select Columns or DISTINCT)?
4. If I merge it with power query, who should I do it.
I am still getting that I dont have any relationships, so this is very annoying.
Regards,
Hello Anonymous
Are you able to share your data so we can see what the strucure actually is?
5 Replies
- jdbuchanan71
Super User
Hello Anonymous
Are you able to share your data so we can see what the strucure actually is?
- AnonymousNot applicable
jdbuchanan71 jdbuchanan71
- jdbuchanan71
Super User
And the only value in both of the highlighted tables is LoanNumber and you want to combine it into one long table with all the values in one column?