Number of customers who paid a debt and made purchases on the same da

[MateusCardoso]

I got 3 tables:

Client:

[Name]

[Clientes ID]

payments
Cliente ID

Date of payment

purchases
Client ID
Date of purchase

I need a messure to return a number of clientes who did a payment and bought samething in the same day.

Imagine, a customer came to a store to do one payment, and took the opportunity to buy something else.

i need build a table showing how many clients did it every day.

[MateusCardoso · Accepted solution]

I got the solution.

Just did one calculated column with concatenate data/client and  one with LOOOKUPVALUE to check if there`s the same infromation between the tables.

thanks

[Ashish_Mathur]

Hi,

Share the 3 datasets and show the expected result.