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 co...
PattemManohar
Community Champion
Community ChampionAnonymous 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.