Add rows for misisng years based on condition

Hi 

You should create a second table to create continuous date. I haven't tried it but it should work.. 

Step 1 : Convert InceptionDate to date format YYYY/MM/DD (easier to get max and min)  

Step 2 : Duplicate your query

Step 3 : In the new query, use Group By function to group data on ID column (use all rows operation)

Step 4 : You will have table for each ID then display min and max value 

Step 5 : Create list in column to list date from min and max date. Use function like number.from

Step 6 : Expand new data 

Step 7 : Merge with your initial query and try to fill down

I hope it will work..