Enter missing date in fact table

[Anonymous]

Hi guys,

Could you please help me on below issue.

I have attached my data herewith. after 11th row date filelds are in different format. I have requirement on

Where ever the Dates are missing in the fact table then i need to write a code to insert that dates as well and carry forward the previous month closing balance to the next missing dates

[fvelascog72]

Hi,

Try this:

if(num([Start Date])<50000,[Start Date],

     if(len(num([Start Date]))=7,

          date(Date#('0'&[Start Date],'DDMMYYY')),date(Date#([Start Date],'DDMMYYY'))))      as "Start Date"