How to Make a Batch ID

[chakrared]

Table 1 - 'Source L1 to L3' 

L1	L2	L3	Batch ID...
value1	anothervalue1	andanothervalue1
value2...etc...	anothervalue2...etc...	andanothervalue2...etc...

All values are text

Table 2 -'L1Distinct'

L1	L1Index
value1	1
value2	2...etc...

L1 is text, L2 is an index value (Number) Values in L1 are related to L1 in 1st table and are only the DISTINCT values in that tables L1 column

Table 3 & 4 'L2Distinct' and L3Distinct' are same as 'L1Distinct' but for L2 and L3 columns

All I want to do is take the columns 'L1Index' on table L1Distinct, 'L2Index on table L2Distinct and 'L3Index' on table L3Distinct and present them as a sequence in the original table....

So if the numbers where 1, 3, 10 for example I'd like 1310 in the column.

I'm new to DAX and struggling to do this. Any help would be appreciated. (Or even advice on an easier way to make a Batch ID based on all distinct values in each column having the same number ?

Thanks! 

[chakrared]

This is an example of the table for visual help

So for example in the last row I'd want to have 2614 as a Batch ID. Problem making this for me with n00b DAX is that these are numbers and that each of the columns is from three seperate tables.

Table relationships are like this: -

Table relationships

[wdx223_Daniel]

hope this can help

[amitchandak · Accepted solution]

@chakrared , Please try  a new column in table Source L1 to L3 

New column = related(L1Distinct[L1Index]) & related(L2Distinct[L2Index]) & related(L3Distinct[L3Index])

[chakrared]

Thank you so much. Works perfectly! 😁