Counting transaction combinations

[Anonymous]

I'm trying to create a matrix that will allow me to see when a void is followed by a no sale via direct query into my company database. 

I think I want to go about this similar to a countif function in excel, using the time when the transaction took place as the if statement, so that if time of void - time of no sale is >10. Can someone help me brainstorm potentional DAX solutions to this?

 The problem I'm having is trying to figure out how to retrieve the sales time, rather than counting, summing, or otherwise manipulating it beforehand so that it will do the computation. It's pretty easy to put a filter(Transaction Type = Void, etc to isolate the transactions I want to look at.

[v-cherch-msft]

Hi @Anonymous 

Sample data and expected output will be helpful to provide an accurate solution.If you need further help,please follow the How to Get Your Question Answered Quickly to post some simplified data and expected output.It would be better if you can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,