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.
If anyone could help me write a dax or power query formula for the two steps below I would greatly appreciate your knowledge.
1. If Column A has a duplicate value, and the value in Column B is the same, then return the record with the most recent date.
2. If Column A has a duplicate value, and the value in Column B is NOT the same, then keep both records.
I'm trying to achieve one formula that can account for both requirements. I've attached images of sample data to better explain.
Solved! Go to Solution.
Could you please explain that why you have duplicate values for first row? I make a test using the following sample table instead, and create a measure in the table.
maxdate = MAX(Table[Date])
Regards,
Lydia
Could you please explain that why you have duplicate values for first row? I make a test using the following sample table instead, and create a measure in the table.
maxdate = MAX(Table[Date])
Regards,
Lydia
I figured out the error. I was adding the table date column instead of maxdate. Your answer worked perfectly, thank you!
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 |
---|---|
105 | |
97 | |
80 | |
66 | |
62 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |