title: How to get time from time dimension with a specific relationship?
body: <p>My data</p>
  <p>Fact</p>
  <pre><code>iddimUser iddimtime
  123       81200
  124       84500
  </code></pre>
  <p>DimTime</p>
  <pre><code>iddimtime FullTime
  81200     08:12:00.0000000
  84500     08:45:00.0000000
  </code></pre>
  <p>Desired Table calculation</p>
  <pre><code>iddimUser iddimtime Time
  123       81200     08:12:00.0000000
  124       84500     08:45:00.0000000
  </code></pre>
  <p>I require to bring to the fact table a specific time from the time dimension base on one of the multiple relationships I have (I have several IdTimes in the fact table).
  I tried this column calculation but getting an &quot;A table of multiple values was supplied where a single value was expected&quot; error</p>
  <pre><code>FullTime = TIME(
      HOUR(CALCULATE( VALUES(DimTime[FullTime] ),
                     USERELATIONSHIP ( Fact[iddimtime], DimTime[iddimtime]))),
      MINUTE(CALCULATE( VALUES(DimTime[FullTime] ),
                      USERELATIONSHIP ( Fact[iddimtime], DimTime[iddimtime]))),
      SECOND(CALCULATE( VALUES(DimTime[FullTime] ),
                      USERELATIONSHIP ( Fact[IniciaProce], DimTime[iddimtime]))))
  </code></pre>