Forum Discussion
Create Hours
Hi everyone,
how can i create static hours based on a condition in power query?
For example, if working shift is MORNING, then 8 hours.
i try to make something like this;
if [ShiftID] = "NORMAL" then #duration(0,8,30,0)*24 else
if [ShiftID] = "OFFICE" then #duration(0,9,05,0)*24 else null)
But if the duration is #duration(0,8,30,0)*24, then the output will be 8.12:00:00. The output that i want is 8:30. Meaning that 8 hours 30 mins.
Can anybody help me with this please? thanks in advance
@New_be , The information you have provided is not de clarifying the problem for me. Please explain with an example.
Can you share sample data and sample output in a table format?
We appreciate your congratulations.
At DAX I canTime to Time(8:30:00)
You can also create time table and join with the time part, you may have change in the time table
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
1 Reply
@New_be , The information you have provided is not de clarifying the problem for me. Please explain with an example.
Can you share sample data and sample output in a table format?
We appreciate your congratulations.
At DAX I canTime to Time(8:30:00)
You can also create time table and join with the time part, you may have change in the time table
https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/