Forum Discussion
Solved
Linking Values from one table to another based on Timestamps
I need some help. I have two tables in Power BI. Table 1 has the GPS coordinates for each unit in my vehicle fleet, and Table 2 has the start and end timestamps for the vehicle status of each unit. ...
OTL Created a custom column (Status) at power query based on the mentioned logics please check the below output and PBIX file
Did I answer your question ? If yes, please mark this post as a solution.
Thanks,
Jai
Jai-Rathinavel
Super User
Super UserOTL Can you paste the sample tables to work with ? So that I can provide you the exact working DAX
Thanks,
Jai
Thanks Jai. I have included a link in my original post to a sample dataset
- Jai-Rathinavel
OTL Requested access to the file
Done
- Jai-Rathinavel
OTL Created a custom column (Status) at power query based on the mentioned logics please check the below output and PBIX file
Did I answer your question ? If yes, please mark this post as a solution.
Thanks,
Jai