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.
Dear members
I have source table which I would like to turn in pivot table. Since my source table is formed from different table columns I cant use simple pivot function.
Matrix view is not a choise also, since I need to use 1st level measure, 2nd level measure etc. separately.
I need to create this desired table as a new table.
Please help me with this issue.
Solved! Go to Solution.
hi, @OSS
Do mean that the three columns are from different table and you haven't put them into one table like this:
If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.
then pivot the table as below:
Select Origin column click Transform -> Pivot column
Result:
Best Regards,
Lin
hi, @OSS
Do mean that the three columns are from different table and you haven't put them into one table like this:
If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.
then pivot the table as below:
Select Origin column click Transform -> Pivot column
Result:
Best Regards,
Lin
@v-lili6-msft wrote:hi, @OSS
Do mean that the three columns are from different table and you haven't put them into one table like this:
If so you need to put them into one table, use Merge queries function in edit query to merge basic tables and then remove the other columns to get a table that contains these three columns.
then pivot the table as below:
Select Origin column click Transform -> Pivot column
Result:
Best Regards,
Lin
How do I do this for a table with more than one column?
I have a table like this.
Month - Year | Tot Avail | Rented | Vacated | Net |
12/1/2018 | 719955 | 31521 | 30450 | 1071 |
11/1/2018 | 707765 | 31244 | 31216 | 28 |
10/1/2018 | 728607 | 34848 | 34184 | 664 |
9/1/2018 | 713773 | 35320 | 35248 | 72 |
8/1/2018 | 695455 | 38134 | 43183 | -5049 |
7/1/2018 | 687525 | 40915 | 33624 | 7291 |
I want it to look like this.
Month - Year | 12/1/2018 | 11/1/2018 | 10/1/2018 | 9/1/2018 | 8/1/2018 | 7/1/2018 |
Tot Avail | 719955 | 707765 | 728607 | 713773 | 695455 | 687525 |
Rented | 31521 | 31244 | 34848 | 35320 | 38134 | 40915 |
Vacated | 30450 | 31216 | 34184 | 35248 | 43183 | 33624 |
Net | 1071 | 28 | 664 | 72 | -5049 | 7291 |
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |