Converts numbers into dates and times in power query.
365 days as columns & 24 hours as rows - hourly data for a year
1) Create a table and make a new query
2) Unpivot other columns
3) Custom column to convert days into dates:
Date.AddDays(#date(2019,1,1),[days]-1))
4) Custom column to add dates to hours:
[date] + #duration(0,[hours],0,0)
5) Delete extra columns and Close & Load
---------------------------------------------------------------------------------
#exceltips #exceltutorials #powerquery
SUBSCRIBE: [ Ссылка ]
Microsoft Office 365, Beta Channel, Version 2103
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- Power Query: split column by delimiter with multiple spaces [ Ссылка ]
- How to combine tables with different columns in excel [ Ссылка ]
- How to combine tables side by side in excel [ Ссылка ]
