Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.