Hi - I am trying to put the lessons into application while using coronavirus data from Johns Hopkins. It motivates me to try to use what I learn. I have no idea how to copy and paste here, control c doesn't work and I can't take a snippet and attach it.... so... If you guys might be patient help me anyways if you read this that would be great! ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- There are a bunch of attributes for date column headers spanning 3 months of individual dates along with Country Region State or Province: 1/22/20 - 1/23/20 - 1/24/20 I want to flip it like a pivot and put it into one column attribute called month. I started to build a table named Month and insert dates, but I can't think how best I could join this with my core data. I would need a primary key identifier to join them and I can't think it through. I googled and got you can pivot in transformation of data set, but it doesn't make sense to me. Can anyone help me think through the best way to do this and give me simple steps to follow? I want to be able to use my Months as a dimension as populate the numbers inside it as count and sum by Month, which is why I want to put it into a dimension. Yes, guys- sites already have it, but how better to learn your new skills after your class than by using real data to do practical things and motivating yourself? What's more motivating than coronavirus data at the moment? #LoveinthetimeofCholera #LoveinthetimeofCoronavirus #PayitForwardWheneverYouCan AS

Hey Christina, Please provide link to the data so I can help you out.

I am not sure which one are you looking at @Christina Crouch, if you can show me your dataset I can tell you how to organize your data inside Power BI so you can put your knowledge into practice.

back

Follow this topic

Christina Crouch

Last answered:

April 10, 2020

Posted on:

April 08, 2020

Power BI Question on CoronaVirus Data from John Hopkins - Any users know who can answer quick and help?

2 answers ( 0 marked as helpful)

Dimitar Shutev

Posted on:

April 08, 2020

Dimitar Shutev

Posted on:

April 10, 2020

Submit an answer

Content