Forum Discussion
Transaction combination DAX
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.
2 Replies
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.
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.
