Creating new column and connecting tables

Hello, I'm newby at Power BI and trying to solve the following qestions: There is a device which collects environmental data with high frequency (1 per second). After each session I manually exp...

Need Help

Show and Tell

amitchandak
6 years ago
Tashon04ka , Try if merge or append can help

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Or You can join in dax

https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Anonymous
6 years ago
Hi Tashon04ka ,

Check the following steps.

1# Add custom column for each table after loading them.

2# Merge tables from session1 then expand table and rename the columns. Then do the same step with tables from session 2.

3# Append merged tables.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.