March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
I am trying to sum the hours from 2 tables which they have no relationship. Table 1 below got the odometer reading of a vehicle every week. Table 2 is when we have replaced and reset the odometer.
When I am after is how can I add the odometer reading before the replacement on top on the weekly reading based on the date and the equipment number (screen shot below only filtered to just 1 equipment, but there are more in the table).
Thanks in advance.
Table 1:
Table 2:
How about appending both the tables in one and then sort it based on date and Equipment number?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
115 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
164 | |
116 | |
63 | |
57 | |
50 |