Forum Discussion

NickOnTheNet's avatar
NickOnTheNet
Frequent Visitor
5 years ago
Solved

Data modelling challenge?

Hi all! I want to produce a report with a chart/charts  comparing revenue by year and month. The data I have is in the form as below. (It also contains columns for Cost of Goods, Qty Sold and Qty P...
Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi NickOnTheNet 

    first you have to unpivot the data columns Rev01 - Rev12 in Power Query.

    Please provide some more sample data.

     

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

     

FrankAT's avatar
FrankAT
Community Champion
5 years ago

Hi NickOnTheNet 

first you have to unpivot the data columns Rev01 - Rev12 in Power Query.

Please provide some more sample data.

 

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

 

  • NickOnTheNet's avatar
    NickOnTheNet
    Frequent Visitor
    5 years ago

    Hi FrankAT ,

    Thanks for your input!

     

    I just looked through YouTube and found a number of videos covering the subject, I just needed to know what to look for.

    This one covered it perfectly: https://www.youtube.com/watch?v=T8Ekr_sLP-0

    I think I've got it from here.

    Every day's a school day 😀

     

    Kind regards ... Nick