Forum Discussion
Solved
Trim all Zeros within a text string - Dax DirectQuery
Hello, I have a text string that has multiple zeros along it. Since I have the data loaded in DirectQuery, I cannot do much in transformation tab and it most probably has to be through DAX, I am...
Not sure how well it will work with DQ, but you can try to use the SUBSTITUTE function and replace "0" with "".
Pat
mahoneypat
Microsoft Employee
Microsoft EmployeeNot sure how well it will work with DQ, but you can try to use the SUBSTITUTE function and replace "0" with "".
Pat