I have my entire GL in a fact table in my model. I want to pull out the work order number from the posting comment which only appears in single GL. I have a clear delimiter and the W/O is always the same length. I can create a new column in the editor by splitting by delimiter and deleting the unneeded columns, but this seems overkill when it only applies to a few thousand rows of the table.
For example, W/O - 0013453 - BATCH:WL149 should return the value of 0013453.
I can use
W/O = Mid(GL_Detail[Posting Comment],6,7)
to create a new column but I don’t really need this column. I am not sure how to create a measure that will dynamically return the value.