cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sunny1984
Regular Visitor

Power BI Transformation

Hi,

 

I have one excel in below format.

 

Available Data   
 1/1/20211/2/20211/3/2021
India   
Total Cases          100,000              200,000              300,000
Total Hospitals               2,000                   3,000                   4,000
Indonesia   
Total Cases            10,000                20,000                30,000
Total Hospitals                  200                      300                      400

 

I want in below format. i tried using power query but i am not able to get it.

 

DateCountryTotal CasesTotal Hospitals
1/1/2021India          100,0002000
1/2/2021India          200,0003000
1/3/2021India          300,0004000
1/1/2021Indonesia10000200
1/2/2021Indonesia20000300
1/3/2021Indonesia30000400
1 ACCEPTED SOLUTION
Jihwan_Kim
Community Champion
Community Champion

Hi, @Sunny1984 

Please check the link down below. It is a short video of my computer screen capture.

 

https://www.dropbox.com/s/8gnmqknnv2orwux/New%20video.mp4?dl=0 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

View solution in original post

2 REPLIES 2
Sunny1984
Regular Visitor

Hi @Jihwan_Kim ,

Thank you very much for your elegant solutions.

Jihwan_Kim
Community Champion
Community Champion

Hi, @Sunny1984 

Please check the link down below. It is a short video of my computer screen capture.

 

https://www.dropbox.com/s/8gnmqknnv2orwux/New%20video.mp4?dl=0 

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors