Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

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's avatar
Syndicate_Admin
Administrator
2 years ago

I understand in my case the place where the filtering would be is in the work column I have placed it and it throws an error in syntaxy

Wages = SWITCH(
TRUE()
[Labor] = "FERTIGATION CONTROL-FILTERED OPERATOR", DIVIDE( Append1[Effective Hours], 12, 0),
[Labor] = "FERTILIZATION", DIVIDE( Append1[Effective Hours], 12, 0),
[Labor] = "IRRIGATION SYSTEM MAINTENANCE", DIVIDE( Append1[Effective Hours], 12, 0),
[Labor] = "OPERATOR INFRA. OF IRRIGATION AND HYDRA.", DIVIDE( Append 1[Effective Hours], 12, 0),
DIVIDE(Append1[Effective Hours],8,0))

  • rsbin's avatar
    rsbin
    Community Champion
    2 years ago

    Syndicate_Admin ,

    Think you are missing a comma "," after TRUE()

    Please try this:  Wages = SWITCH(
                                                  TRUE(),