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 all,
I'm trying to remove certain duplicates in specific a column but keep all the rows. I'm working on a calculated table and the second red rectangle is what I want to achieve:
The 1st column contains IDs.
I hope for the red result if the IDs AND the values the green rectangle are duplicates. For the future: I might have more than 2 ID and green rectangle values as duplicates.
If it helps, the removing can be based on the penultimate colomn, which is a date. The problem is that those dates can be duplicates too...
Do you think it's possible through DAX?
Regards,
Pingouin Puni
This should give you the desired result.
Column =
VAR __firstDate =
CALCULATE(
MIN( 'Table'[penultimate] ),
ALLEXCEPT( 'Table', 'Table'[Mission en cours_3.2] )
)
RETURN
IF( 'Table'[penultimate] = __firstDate, 'Table'[Dispo par mission] )
Hi @Mariusz ,
Thank you for answering !
Your solution worked, but not as I intended to. I realized I didn't give the whole picture so I'll try to give as much info as I can through the attached .pbix and the following :
The formula for "Test" is this one :
Test =
IF(
Test[Nb of ID]>1;
IF(
Test[State of the mission]=Test[Mission_Test (groupes)];
Test[Avaliability];
BLANK()
);
Test[Avaliability]
)
For a duplicate ID :
I hope I explained it clearly this time, let me know if I didn't 🙂
Regards,
Pingouin Puni
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 |