
Announcements
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?