Forum Discussion

NickOnTheNet's avatar
NickOnTheNet
Frequent Visitor
6 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
    6 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
Icon for Community Champion rankCommunity Champion
6 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)