Hi I am using PQ (in Excel. I have data for a number of non-sequential days. Each time data is recorded there are two records created holding Date, Code, Type, Value – one for Type A and One for Type B. I need to create a table that takes the t_Initial table and then for each date in the range f…

Fill in Records for Missing Dates

mspanic August 18, 2024, 10:17pm 2

You can check Enteprise DNA Data Mentor Tools Advisor :

For Date Dimension - how to create you can check Melisa’s Date M function:

Hope it helps.