Forum Discussion
Syndicate_Admin
2 years agoAdministrator
Splitting with text
Good day I would like your support in solving the following question within power bi. I need to divide the number of hours worked by 8 but I have workers who have a 12-hour shift and these need t...
Syndicate_Admin
2 years agoAdministrator
I've tried to enter as you indicate, it would be like that, right?
In the red column is the total hours and the green column would be where the conditional division would have to go with those 4 positions.
rsbin
2 years agoCommunity Champion
You have misunderstood the syntax.
[Position] is the name of the field. So in your case I assume this to be [Trajadore].
I have used the letters A, B, C, D as placeholders for the actual text of the Positions that need to be divided by 12.
So instead of "A", you enter "....Operador Filtrado ".
Instead of "B", you enter "Fertilizacion". Enter the text exactly how it appears in your [Trabajado] column.
Use the exact text of the position