Forum Discussion

DaxRain's avatar
DaxRain
New Member
5 years ago
Solved

How to Remove Left Most Character if it is a dash

I have a problem in Power BI I hope people can help with. I am using a table of columns to construct mapping files that are exported into CSV files later. The problem I have is some of the fields hav...
Need Help
Tutorial Requests
  • Fowmy's avatar
    Fowmy
    5 years ago

    DaxRain 

    Addthis as Custom Column in Power Query:

    =if Text.Start([VALUES],1)="-" then Text.Middle([VALUES],1,Text.Length([VALUES])-1) else [VALUES]

    ________________________

    If my answer was helpful, please consider Accept it as the solution to help the other members find it

    Click on the Thumbs-Up icon if you like this reply 🙂

    YouTube  LinkedIn