Forum Discussion
Populating the value once when there is duplicate.
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
3 Replies
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
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?
