Forum Discussion

Regular Visitor

5 years ago

Solved

How to Make a Batch ID

Table 1 - 'Source L1 to L3' L1 L2 L3 Batch ID... value1 anothervalue1 andanothervalue1 value2...etc... anothervalue2...etc... andanothervalue2...etc... All values are text...

DAX

SEQUENCE

amitchandak
5 years ago
chakrared , Please try a new column in table Source L1 to L3

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

chakrared

Regular Visitor

5 years ago

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