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 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 |
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |