Power Query - Calculate Net Working Hours !!
Автор: BA Sensei
Загружено: 2023-05-07
Просмотров: 4288
Описание:
Calculating the net amount of hours between a start and end time is a common requirement but for some strange reason it isn't provided for in power query so in this video I show you how to create a networking hour function that you can reuse in your power query projects. You can also just copy the code from the file link below and apply it immediately.
#workinghours #data #dataanalytics #excel #powerquery #powerbi #powerbidesktop #accounting #excelformula #calculation
Link
File created for this video
https://github.com/jbotes/powerbiTuto...
Other Links
List Generate
https://learn.microsoft.com/en-us/pow...
sharp duration
https://learn.microsoft.com/en-us/pow...
table from list
https://learn.microsoft.com/en-us/pow...
splitter split by nothing
https://learn.microsoft.com/en-us/pow...
value types
https://learn.microsoft.com/en-us/pow...
sharp time
https://learn.microsoft.com/en-us/pow...
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке: