Run R Script on Power BI Column

Question

I am using a dataset in PowerBI with many columns and has information on the incident tickets.

I am getting an error data for time format and I wrote an R Function which returns time

calculateHours <- function(hours) {
  x <- trunc(hours/24)
  rest <- mod(hours,24)
  y <- trunc(rest/10)
  z <- mod(rest,10)
  result <- (((x+y)*10)+z)
  return(result)
}

How can i solve this 

Answer 1

Follow the code below and link:

# 'dataset' holds the input data for this script

myfunction <- function(x) 
{
    return (x + 1)
}

dataset$NewNumber <- myfunction(dataset$Number) ## apply function and add result as new column
output <- dataset ## PowerBI uses "output" as result from this query step

If you want to learn more about Power BI, then read Power BI Tutorial. Also, enroll in Power BI Training to become proficient in this BI tool.