Create a Master Calendar with Min and Max Date...
Now create a Temp Table with Distinct Car and do a Cartesian Join with Above Calendar Dates with All Distinct Car...
You can Concatenate your original table with the Temp table with Where Not Exists condition.
Now create a final table as per your requirements....
If you still don't get the desired output, please provide us sample data file along with your required output..
would love to help you..
Look at the below script.
Date(InvoiceDate) AS InvoiceDate,
Year(InvoiceDate) AS Year,
'Q' & Ceil(Month(InvoiceDate) / 3) AS Quarter,
Month(InvoiceDate) As Month,
Day(InvoiceDate) As Day,
Week(InvoiceDate) As Week;
Load Date(MinDate + IterNo() -1 ) AS InvoiceDate While (MinDate + IterNo() - 1) <= Num(MaxDate);
Min(InvoiceDate) AS MinDate,
Max(InvoiceDate) AS MaxDate
Also look at the below post