String Operation Formula

[Syndicate_Admin]

IF CONTAINS((Mid(upper([Name]),1,Find(upper([Name]),'.')-1)),"-") THEN
(Mid((Mid(upper([Name]),1,Find(upper([Name]),'.')-1)),1,Find((Mid(upper([Name]),1,Find(upper([Name]),'.')-1)),'-')-1))
ELSE(Mid(upper([Name]),1,Find(upper([Name]),'.')-1))

How can I achieve this in Tableau Calculation in Power Query Editor? 

[Anonymous]

Hi @Syndicate_Admin ,

Any updates?

As @lbendlin  mentioned, please share more details to help us clarify your scenario.Like some dummy data, your expected output...

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

How to Get Your Question Answered Quickly - Microsoft Power BI Community

Best Regards,
Eyelyn Qin

[lbendlin]

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523