Blanks being returned in Calendar (Dates) Table

[Aree]

I built a simple calendar table which runs from 2018 to 2025.

Now I am building columns to calculate the Financial Period (month) and Year. 

My function basically adds 6 months and then aggregated either the month number or Year as the result.

In a weird twist of faith the tail end of my dates table refuse to use this calculation, is there a limitation that i am unaware of?

These blanks that are being returned are causing chaos as it prevents me from using the sort by function... 😞

[Aree]

Quick update further some testing.

There seems to be a limitation that seems to created when you generate a Calendar table.

It prevents you from calculating dates outside of that table range. 

I know this sounds crazy but here is a second test

The Dates Column is sorted in ascending order and using a simple date add function to calculate the date -1 month generates a blank when the result is outside of the inital range of the table i.e. before July-2017.

[Aree · Accepted solution]

Have some thinking I will have to just use an IF statement to test for blanks and then adjust the function is it exist.

FY Year = IF( ISBLANK(DATEADD('Dates 2'[Date], +6, MONTH)),  YEAR(DATEADD('Dates 2'[Date], -6, MONTH)) +1, YEAR(DATEADD('Dates 2'[Date], +6, MONTH)))