DAX Extract Right of -

[Anonymous]

Hello All, I need help (again).

I have a column called Merge which has 2 dates seperated by a - or a date and tex seperated by a -.

I need to create a DAX formula that extracts anything to the "Right" of the -. I have been trying, but unsucessful. Unfortunately I can't do this in Power Query becuase this is all based on other new calculated columns I had to create in the data table with DAX.

Sample image attached showing desired output.

[amitchandak · Accepted solution]

@Anonymous , Try like

new column = right([merge], len([merge]) - SEARCH("-",'Table'[merge],1,0)+1)

[Anonymous]

Thanks! Works great except it is also extracting the hyphen "-" (ex: -4/2/20). I need it to extract everything to the right except the hyphen.

How should I modify?

[Anonymous]

Thanks---I removed the +1 and it did the trick!

Thanks again!