Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Put values in different rows into two columns

Hi,

 

I have an excel spreadsheet as my dataset, that looks like this:

DateTimeTypeCount
1/12/2021 10:00:00 am  NS597
1/12/2021 10:00:00 amSu494
1/12/2021 11:00:00 amNS  658
1/12/2021 11:00:00 amSu553

 

And I want each date to have its own row, and each type to have its own column like this:

DateTimeNSSu
1/12/2021 10:00:00 am  597  494
1/12/2021 11:00:00 am658553

 

How would I do this with power query? Thanks in advance

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Pivot the last two column in power query

https://radacad.com/pivot-and-unpivot-with-power-bi

 

Or create measure like these and use in table visual with date

 

Ns = countx(filter(Table, Table[Type] ="Ns"), [Count])

 

Su= countx(filter(Table, Table[Type] ="Su"), [Count])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

This screenshot should say it all

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

@Anonymous , Pivot the last two column in power query

https://radacad.com/pivot-and-unpivot-with-power-bi

 

Or create measure like these and use in table visual with date

 

Ns = countx(filter(Table, Table[Type] ="Ns"), [Count])

 

Su= countx(filter(Table, Table[Type] ="Su"), [Count])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.