Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello
i want to connect two spreadsheets. One Spreadsheet has more rows than the other. Each spreadsheet has an time stamp on which the connection should happen. The problem is that the time stamps are not equal. Every time stamp of the small spreadsheet should be connected with the next time stamp of the big spreadsheet. In the pictures below you can see the two spreadsheets with a red box around the data which should be connected.
Small spreadsheet: https://www.bilder-upload.eu/bild-e5b730-1556007354.png.html
Big spreadsheet: https://www.bilder-upload.eu/bild-807077-1556007149.png.html
Thank you in advance
Solved! Go to Solution.
Hi @Anonymous ,
Based on my test, you could create a new calculated column to create relationships with the other table:
Column = [Time]+1/(24*60*60)
Result:
Regards,
Daniel He
Hi @Anonymous ,
Based on my test, you could create a new calculated column to create relationships with the other table:
Column = [Time]+1/(24*60*60)
Result:
Regards,
Daniel He
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 |
---|---|
99 | |
98 | |
80 | |
75 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |