Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Compare hour from different table

Hi all

I have a column Dim Hours, that contains 24 hours .

table a

and I have other column in other table that contains some hours for exemplo 

table b
12:00:00
12:30:00
17:00:00

I would like to compare this date for exemplo
IF( tableA.hour >= tableB.hour,1,0)

The problem is that the table A there are a lot line and Table B they are 10 line for exemplo, so i need compare.


Thanks a lot


Compare
hour

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , do these tables has any thing in common.

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

     

    You can actually create a new column in the required table. and then use that for you calculations.

    Example in video - https://www.youtube.com/watch?v=czNHt7UXIe8

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      Thanks a lot,
      with this cod I could solve my problem, make  a looping comparind the datas from the tables

      Hora Cor Parada =

      var selecthora = SELECTEDVALUE(E_DIM_HORA[HORA])
      var result =
      CALCULATE(
      SELECTEDVALUE(Fato[HoraInicio]),
      FILTER(Fato,
      selecthora >= (Fato[HoraInicio])&&
      selecthora <= Fato[HoraFim] ),Fato[MOVIMENTO] = "2")
      return
      If(result,1,0)