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 ...
Compare
hour
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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)