Creating Logic to find whether columns in one table matches other columns in other table

[sivarajan21]

Hi Team,

I have 2 tables:

Door table as below:

Store Status table as below:

They are modelled as below(let me know if we can better model it-suggestions are welcomed):

Now, I need to create a logic(Breach) to find when Door Table - Status column being Open when Store Status table - Status column being Closed (indicated by - 'C').

During this logic, we have to make sure it satisfies below conditions:

• DateTime column of Store Status table should match the createdon column of Door table
• Store id column of Store Status table should match the siteid of Door table

Output should return 1 if the conditions meets else 0.

Could you please help me create a logic for this?

PFA file here B&M.pbix

Thanks in advance!

@marcorusso @tharunkumarRTK @Ahmedx @Greg_Deckler @dufoq3 

[lbendlin · Accepted solution]

Wouldn't this data model make more sense?

[sivarajan21]

Hi,

 I have closed this query as there was no further progress.

thanks

[sivarajan21]

Hi @lbendlin Sir,

Thanks for your quick response!

Is it possible to achieve the logic(Breach) which i described above using this model?

Many thanks in advance!

@lbendlin @marcorusso @tharunkumarRTK @dufoq3 @Ahmedx 

[dufoq3]

Hi @sivarajan21, do not tag me in every single post please. Thank you.