Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi friends,
I need some help in achieving the below using DAX. Table 1 is with Unique ID and table 2 is with duplicated ID, so i want to pull the value from Table 1 where i need to populate the value only once when there is duplicate ID's.
Table 1
ID | Value |
A | 2 |
B | 4 |
C | 5 |
D | 6 |
E | 7 |
F | 9 |
Table 2
ID | Value |
A | 2 |
B | 4 |
B | |
C | 5 |
D | 6 |
Thanks in Advance
IDK if i would do that with dax, I would just do it in the power query editor, and remove duplicates.
Is there a particular reason you would want a blank value with a duplicate ID?
Im not sure im understanding what you want, but if I had to guess...
Your wanting to Pull the value for B in Table 2 Since it has a duplicate ID (B) in it?
So your end result would be 4?
Or what is your expected output supposed to look like?
@eTribble Thanks for the quick turn
Yes you are right. When i have a duplicate id i need to have the value for first id and the remaing should be blank.
this is my expected result
ID | Value |
A | 2 |
B | 4 |
B | |
C | 5 |
D | 6 |
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |