Force Convertion of String to Number using Dax
Hello everyone, I have a column that was created with DAX (hence cannot use power query) as a Text that needs to be converted to Number. However, sometimes on this column there are non-numerical, non-roman characters as the source is taken from multiple languages around the world. When using CONVERT function, if only in one of the rows there is a special character, all rows are changed to #Error. I want to know if there is a function that forces the convertion (omitting or deleting the special character) or at least that changes to #Error only the row with the problem, and not the entire column. Many thanks,
Convert text value to long time
Hello comunity. I have duration value in sec(integer), I use DAX to convert it to time Movement Time = VAR Duration ='Summary table'[Duration(sec)] VAR Hours =INT ( Duration / 3600) VAR Minutes =INT ( MOD( Duration - ( Hours * 3600 ),3600 ) / 60) VAR Seconds =ROUNDUP(MOD ( MOD( Duration - ( Hours * 3600 ),3600 ), 60 ),0) VAR H =IF ( LEN ( Hours ) = 1, CONCATENATE ( "0", Hours ),Hours) VAR M =IF (LEN ( Minutes ) = 1, CONCATENATE ( "0", Minutes ),Minutes) VAR S =IF (LEN ( Seconds ) = 1, CONCATENATE ( "0", Seconds ),Seconds) RETURN CONCATENATE (H,CONCATENATE ( ":", CONCATENATE ( M, CONCATENATE ( ":", S ) ) )) Then I try appy time format for this column and got error So this perfectly works untill my time value less or equall to 23:59:59. question - how can I convert duration to time like hhh:nn:mm and apply time format as well
