Transaction combination DAX

[Anonymous]

I am trying to create an expression that will allow me to know when one type of transaction is followed by another, I.e. A void followed by a no sale. I have a table called OP_Identifier, with the column Identifier Description, which gives the transaction type, a table called Daily_Reporting_Fact which holds a column for amounts, and a table called timeofday with a column called timeofday_seconds, which I'm wanting to use as the filter so that only transactions within 10 seconds of each other are registered.

I'm pretty sure this is going to require a calculate, count, filters argument, but as to exactly what, it's above my head.

[PattemManohar]

@Anonymous  Thanks for the description of your problem statement. Could you please post the sample test data and expected output which help to provide an accurate solution.

[Anonymous]

I'm dealing with direct query so giving a sample of the test data is rather difficult, but here are some tables with it (tuneofday_second_of_day runs through 86,400).

The idea would to be to create a matrix that reads as follows,

where if an error correct was followed by a no sale, within X seconds, it would populate cell 1:1, and so forth.