DAX need help for function

[Anonymous]

What should the formula in Power BI look like if you always wanted to take the first two digits and if the second digit is a minus then the third and fourth digits as you can see in the attached screenshot.

[Anonymous · Accepted solution]

@Anonymous , try this calculated column:

NewColumn = 
  IF(
    MID('Table'[ExistingColumn', 2, 1) = "-",
    MID('Table'[ExistingColumn', 3, 2,
    LEFT('Table'[ExistingColumn',2)
  )

[Anonymous]

@Anonymous , if my suggestion solved the problem you posted, then please mark the answer a Accept As Soultion. This helps other members that are searching for the same or similar problem know what worked.