Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I have 2 tables and I would like to pull the electrical safety check date from one table into the other based on the date of completed job. So the electrical safetfy check date would be the ealiest one after the date of completed job.
Can any one please help?
Job | Date of completed job | Electrical safety check date | Electical safety check dates | ||||||
1 | 1/4/2012 | 1/5/2012 | a | 1/1/2012 | |||||
2 | 1/1/2012 |
| b | 1/2/2012 | |||||
3 | c | 1/3/2012 | |||||||
4 | d | 1/4/2012 | |||||||
5 | e | 1/5/2012 | |||||||
f | 1/6/2012 |
Solved! Go to Solution.
hI @G0ggs ,
Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello
I am trying to pull the earliest electrical safety check date in one table after the date of completed jobs into the date of completed jobs table can anyone please help?
Job | Date of completed job | Electrical safety check date | Electical safety check dates | ||||||
1 | 1/4/2012 | 1/5/2012 | a | 1/1/2012 | |||||
2 | 1/1/2012 |
| b | 1/2/2012 | |||||
3 | c | 1/3/2012 | |||||||
4 | d | 1/4/2012 | |||||||
5 | e | 1/5/2012 | |||||||
f | 1/6/2012 |
@G0ggs , what is relation between to table .
simple min
min(Table[Electrical safety check date])
or check 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
hI @G0ggs ,
Please refer to my .pbix file.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@G0ggs ,what is relation between to table .
simple min
min(Table[Electrical safety check date])
or check 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |