Forum Discussion

ggalstyan's avatar
ggalstyan
Frequent Visitor
3 years ago

multiple ifs with multiple conditions

Hello everyone, I am trying to solve the following issue with multiple ifs and conditions if eventnumber=eventnumber and unit's(starts with BLS or RA) dispatch time is after unit's dispatch time(st...
General Comment
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

ggalstyan , Based on what I got

new column =

var _cnt = countx(filter(Table,[eventnumber] = earlier([eventnumber])  && ( left([unit],3) = "BLA" || left([unit],2) = "RA") && [Entry Time] > earlier([Entry Time] ) ),[eventnumber])

return

if(isblank(_cnt), "No", "Yes")

 

Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8

ggalstyan's avatar
ggalstyan
Frequent Visitor
3 years ago

amitchandak @Thanks I Will try this tomorrow and let you know if works: I believe I understand the concept now.