Convert Text Data type to whole number
(1) Hi Power BI folks, can you assist me in how to convert this text dataype which written in terms of day,hour,minute and second to seconds because I cannot use the AVERAGE(V_SLA[Business elapsed time]) measure (2) I need to convert it into whole number, find the average and then change the format back to original (3) It returns error when I convert it to duration data type
