How to do it...

To implement this recipe, do the following:

1. Add a column to the R03_Table table using the following formula:

Unix2UTC = 
    VAR __UnixEpoch = 'R03_Table'[UnixTime]
    VAR __Time = DIVIDE(__UnixEpoch, (60*60*24))
    VAR __SourceBaseDate = DATE(1970, 1, 1)
RETURN (__SourceBaseDate + __Time)

2. Ensure that the data type for this column is set to Date/Time.