Created New Date Table, now I've got a blank row

[ElliotP]

Morning everyone,

I've been creating new date tables from my Big Date table as suggested as so I can have more flexibility with the dates, but when I woke up this morning and created a new date table for a new visualisation, it all of a sudden gave me a blank row in the created table.

My Code;

DeviceBreakdownDateTable = ALL('BasicCalendarEnglish'[MonthInCalendar],'BasicCalendarEnglish'[DateKey])

Photo:

https://gyazo.com/4efafb28698e60f8f01141d291781a5f

This stops me from creating a relationship between the original dataset and my date table due to the missing intermediate data.

Any ideas, I've got no clue why this has just started happening.

[ElliotP · Accepted solution]

Fixed it.

I had my date table set to update with a new day everyday and I hadn't refreshed my data for the day.