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.
Hi! I have two different tables each very important in it own datapoint that they throw. The thing is Related will not work in this case becuase are absolutely no coloumn on whom i can remove duplicate to link with the other coloumn.The table is as follows:
I hve the d list also with a lot of duplicates but in EX I do it as vlookup(d,sheet name[col],1,0) something like this so that in the end i can count the number of times the code repeats in the second file
There is a LOOKUP function in DAX:
https://msdn.microsoft.com/en-us/library/gg492170.aspx
Also, you can check out my article here as well, which has some various methods of replicating lookup functionality:
my both fields are not having any unique columns they both have a lot of duplicate values. thus am not able to use the related function. is there any other way?
Maybe you can create a key column with two other columns using the concatenate formula.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |