Forum Discussion
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...
chakrared , Please try a new column in table Source L1 to L3
New column = related(L1Distinct[L1Index]) & related(L2Distinct[L2Index]) & related(L3Distinct[L3Index])
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
- amitchandak
Super User
chakrared , Please try a new column in table Source L1 to L3
New column = related(L1Distinct[L1Index]) & related(L2Distinct[L2Index]) & related(L3Distinct[L3Index])
Thank you so much. Works perfectly! 😁
- wdx223_Daniel
Community Champion
hope this can help
