Forum Discussion

BJE's avatar
BJE
Icon for Helper I rankHelper I
4 years ago
Solved

Changing the format of column headers

I have a dataset that has column headers that refer to the FY with the data in each of the columns being dollar amounts, similar to below:   Item FY 2020-21 FY 2021-22 FY 2022-23 FY 2023-24 ...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi BJE ,

     

    You need to 'normalise' your table structure.

    Select your item field in Power Query then go to Transform tab > Unpivot Columns > Unpivot Other Columns.

    This will now give you a single column of your year values on which to perform functions to convert to a recognisable date format, as well as a single column on which to add a relationships.

     

    This table structure will also make it WAAAY simpler to create measures based on your values data.

     

    Pete

BA_Pete's avatar
BA_Pete
Icon for Super User rankSuper User
4 years ago

Hi BJE ,

 

You need to 'normalise' your table structure.

Select your item field in Power Query then go to Transform tab > Unpivot Columns > Unpivot Other Columns.

This will now give you a single column of your year values on which to perform functions to convert to a recognisable date format, as well as a single column on which to add a relationships.

 

This table structure will also make it WAAAY simpler to create measures based on your values data.

 

Pete