Reply
SDVN
Frequent Visitor
Partially syndicated - Outbound

Help needed: Pivot for half of the the table

Dear Experts,

 

Greetings! I am new for power BI and I was given a project to work on to practice but this data in excel seems little conplicated to handle in Power BI. 

 

The data that am using is as shown in the picture. I want to get the count of the Monthly count of "Trial" of 2023. But you can see that years (2023 and 2024) are not in a single coulmn. The years are mentioned in a merged cell about the months. So i have 2 sets of months, one for 2023 and another for 2024. How do I analyse the monthly data of each year? Can someone help? Please let me know if i have failed to mention any details. Thank you so much 🙂

 

If you want the sample data to try, do let me know. I can create a new one and share. 

 

SDVN_1-1681132936453.png

 

 

Regards,

Sid 

1 ACCEPTED SOLUTION
DOLEARY85
Resident Rockstar
Resident Rockstar

Syndicated - Outbound

Yeah i can see where you're struggling, not the best data set to start off with,

 

could you remove the columns for 2024, promote the row headers and pivot the data in the month columns using power query?

View solution in original post

8 REPLIES 8
SDVN
Frequent Visitor

Syndicated - Outbound

Thank you so much! I have just started to learn Power BI and there is so much to learn, with the support of kind experts like you, the learning journey wouldn't be very difficult. 🙂 Thank you for the help..

DOLEARY85
Resident Rockstar
Resident Rockstar

Syndicated - Outbound

No problem, happy to help 🙂

SDVN
Frequent Visitor

Syndicated - Outbound

Sure! Thank you so much for helping 🙂 here is the data: 

 

https://docs.google.com/spreadsheets/d/1tqqj0_lbCIUPqBrJKSVlw7G-2zoPSb70/edit?usp=share_link&ouid=10...

 

Regards,

Sid

DOLEARY85
Resident Rockstar
Resident Rockstar

Syndicated - Outbound

Hi,

 

if you have the sample data i'd be happy to take a look for you,

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Syndicated - Outbound Sure! Thank you so much for helping :slightly_smiling_face: here is the data: https://docs.google.com/spreadsheets/d/1tqqj0_lbCIUPqBrJKSVlw7G-2zoPSb70/edit?usp=share_link&ouid=10... Regards, Sid
DOLEARY85
Resident Rockstar
Resident Rockstar

Syndicated - Outbound

Yeah i can see where you're struggling, not the best data set to start off with,

 

could you remove the columns for 2024, promote the row headers and pivot the data in the month columns using power query?

Syndicated - Outbound

Okay.. can i do pivot for all the months columns? Can you help me how to do that? I could do only once (Unpivot), by selecting the "Jan" column but that did not help. Would you mind helping me understand a bit? 🙂 

 

SDVN_0-1681150737987.png

 

DOLEARY85
Resident Rockstar
Resident Rockstar

Syndicated - Outbound

No problem,

 

Just select all the month columns first before selecting unpivot

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)