i have following table
Employee_Name Join_Date Department_Join Date
Neema 25-04-2018 04-05-2018
Olga 15-05-2018 27-08-2018
I Expect as following table
how can i acheive this?
Go to Solution.
To achieve this, you need to Unpivot the table data.
In query editor; load it as two tables, then append the the tables.
i have 3 columns in a single table.
how can i append 2 columns into a single column within a table
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!
Check out what's new in the Power BI Community!