Forum Discussion

EricHD's avatar
EricHD
Frequent Visitor
2 years ago
Solved

Graph Date on x-axis when column headers are dates

I have an expense/budget table where descriptions are listed by column and yearly/monthly actual, forecast and budgeted financial information as headers as shown below: Region Team Project FY2...
  • ryan_mayu's avatar
    2 years ago

    EricHD 

    in pq ,select the first 3 column and unpivot others. then all the date data will be in one column

     

    not sure what's the expected output based on the sample data you provided. Hope this can help to point the right direction for you.