Compare hour from different table

[Anonymous]

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

[amitchandak]

@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]

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)