Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
@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: -
hope this can help
@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! 😁
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |