Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello All,
My goal is to find the value in the "Key" column for every row in the "Unique Tool ID" column and return that matched rows "Date" value. The matched row can be before or after the current row in my dataset. The values currently in the "Original Date" column are my expected results. I am trying to solve for the "Original Date" column.
Key | Date | Unique Tool ID | Original Date |
ID1.0 | 1/1/24 | ID1.0 | 1/1/2024 |
ID4.0 | 1/3/24 | ID4.1 | 1/8/2024 |
ID3.0 | 2/20/24 | ID3.0 | 2/20/2024 |
ID1.0 | 2/1/24 | ID1.1 | 1/1/2024 |
ID4.0 | 1/8/24 | ID4.0 | 1/8/2024 |
Thank you.
Solved! Go to Solution.
Use lookup function, i hope it will work.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
60 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |