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 v...
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 |