Check if another row within 3 future days exists for an ID?

[a_fman]

Have a dataset with IDs, visit dates, and other details. I have a need to provide a count of the number of times a particular ID has a visit with another visit some time in the subsequent 3 days.

Any ideas? Everything so far has not worked for me.

[v-jiascu-msft]

Hi @a_fman,

Could you please provide a sample in TEXT mode? The PBIX file would be great. 

Best Regards!

Dale

[a_fman · Accepted solution]

Ended up just building out a few layers of nested query on this as a direct database query, seemed like the fastest option.