Data modeling and relationships

[Anonymous]

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,

[jdbuchanan71 · Accepted solution]

Hello @Anonymous 

Are you able to share your data so we can see what the strucure actually is?

[Anonymous]

@jdbuchanan71 jdbuchanan71

[jdbuchanan71]

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?

[Anonymous]

@jdbuchanan71  I want loannumber (and Arrearsbucket) to have relationship with Servicing_Defaultmanagement and Servicing_Loanpart. So the red cirkeled columns are my dimension tables.

Loannumber colums is a kind of CustomerID column. 

I subsetted loannumber and arrearsbucket as this : 

Loannumber2 = DISTINCT(Servicing_LoanPart[LoanNumber])

I dont know whether it is good

[jdbuchanan71]

I'm sorry, in your picture you have the relationship already set.  Is it not working the way you want it to?  I'm not understanding the problem you are trying to solve.  Do you have a visual in power BI that shows the wrong results and can you give an example of what the results should be?