extrobe
1/31/2017 - 1:47 PM

Remove Leading Zero's from String in DAX

Remove Leading Zero's from String in DAX

NumberXNoLeadingZero = IF( ISERROR( VALUE( 'Table'[NumberX] ) ), 'Table'[NumberX], CONCATENATE( VALUE('Table'[NumberX]), "" ) )