Forum Discussion

AT_jda_powerbi's avatar
AT_jda_powerbi
Regular Visitor
3 years ago
Solved

Complex data transformation with dates and workload

Dears,   Firstable thank you 😉 I'm facing a difficulty for the file that i need to treat when importing in Powerbi.  The context is the following : i need to create some KPI based on input excel...
Need Help
  • artemus's avatar
    artemus
    3 years ago

    In power query you would select all the non-date columns, and choose Transform -> Unpivot Columns -> Unpivot other columns. This will replace the date columns with an Attribute column and a Value column. You would rename these to Dates and Workload respectivly. Then you can convert the date column to the date type.

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, AT_jda_powerbi ;

    As artemus said, You could select those column then unpivot.

    Then change the column's type and name.

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, AT_jda_powerbi ;

As artemus said, You could select those column then unpivot.

Then change the column's type and name.

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.