Date Range Gaps

[pvara]

I have a data set, that has Dates spanning from 2014 thru 2019.

The task is find Date Gaps within the data set.

What would be the best approach to tackle this ask?

For example lets say there are 50 transactions per quarter for the given data set, however, in 2019 Q2 there was Zero.

I was looking into AB Trend but couldn't get that to work, and I think I am over engineering this. Your thoughts?

Thank you

[CharlieS · Accepted solution]

I would use the Generate Rows, or other tools to generate all possible records, Join those to the actual data and use those Join results to identify the gaps.