Last answered:

10 Apr 2020

Posted on:

08 Apr 2020

0

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

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
2 answers ( 0 marked as helpful)
Instructor
Posted on:

08 Apr 2020

0
Hey Christina,   Please provide link to the data so I can help you out.
Instructor
Posted on:

10 Apr 2020

0
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.

Submit an answer