Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello,
I have a table similar to below:
| Jan | Count | Feb | Count | Mar | Count | ||
| 01.01.2018 | 5 | 01.02.2018 | 8 | 01.03.2018 | 30 | ||
| 02.01.2018 | 20 | 02.02.2018 | 20 | 02.03.2018 | 2 | ||
| 03.01.2018 | 10 | 03.02.2018 | 1 | 03.03.2018 | 14 | ||
| 04.01.2018 | 3 | 04.02.2018 | 50 | 04.03.2018 | 33 |
Which I want to convert to:
| Month | Count |
| 01.01.2018 | 5 |
| 02.01.2018 | 20 |
| 03.01.2018 | 10 |
| 04.01.2018 | 3 |
| 01.02.2018 | 8 |
| 02.02.2018 | 20 |
| 03.02.2018 | 1 |
| 04.02.2018 | 50 |
| 01.03.2018 | 30 |
| 02.03.2018 | 2 |
| 03.03.2018 | 14 |
| 04.03.2018 | 33 |
I tried pivoting the columns but that only seems to work well for the dates. Not sure how else to proceed. Any help appreciated.
Solved! Go to Solution.
There may be a better option, but you could copy the table 2 times, for the first one, just select Jan and Count and remove other columns. Then second Feb and Count and so on
Then you would have 3 tables
Jan Count
Feb Count
Mar Count
Here you can just do an append and have it all in 2 columns
There may be a better option, but you could copy the table 2 times, for the first one, just select Jan and Count and remove other columns. Then second Feb and Count and so on
Then you would have 3 tables
Jan Count
Feb Count
Mar Count
Here you can just do an append and have it all in 2 columns
There may be a better option, but you could copy the table 2 times, for the first one, just select Jan and Count and remove other columns. Then second Feb and Count and so on
Then you would have 3 tables
Jan Count
Feb Count
Mar Count
Here you can just do an append and have it all in 2 columns
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 50 | |
| 49 | |
| 35 | |
| 15 | |
| 14 |
| User | Count |
|---|---|
| 92 | |
| 75 | |
| 41 | |
| 26 | |
| 25 |