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.
Hi,
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
Employee_Name Date
Neema 25-04-2018
Neema 04-05-2018
Olga 15-05-2018
Olga 27-08-2018
how can i acheive this?
Solved! Go to Solution.
Hi,
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
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 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |