question

Jonie-9159 avatar image
0 Votes"
Jonie-9159 asked ·

Pls help to write this formula

Column Employee ID have 2 type of data (Number & Text). Number ID (Ex: 20000654) belongs to permanent staff & Text (Outsoure) belongs to Temp. I want to add one more customs column & insert formula to split Perm/Temp. Can someone help me?

power-query-m
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Jonie-9159

Not quite clear to me. Please provide a few examples of your 2 columns + the expected results

2 Votes 2 ·

1 Answer

MartijnVO10 avatar image
0 Votes"
MartijnVO10 answered ·

If you want to split this table into a table of permanent staff and outsource staff, you could split column on first number, then reference this query twice (one for permanent staff and one for outsource staff), where you filter on null values on the opposite column

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.