question of datesinperiod

[toziu]

there are dates from 2017/1/1 to2018/9/6

when i create a table:  table = datesinperiod ('sheet1'[date] , max('sheet1'[date]) , -1,year),the result is that it starts from 2017/10/1 to 2018/9/6,just 341days.

if i try : table = datesinperiod （'sheet1'[date] , date (2018,9,1), -1 ,year）,the result is correct ,from 2017/9/2 to 2018/9/1 

and other dates are also correct ,just the max(date) is wrong ,what is the problem?

thanks very much,guys.

[HotChilli]

I think you're probably getting into trouble here by not using a proper Dates table.  DATESINPERIOD needs a contiguous dates table to work correctly.  That's just an educated guess since I can't see your data.

--

If you want to create a dates table use CALENDAR function. 

[toziu · Accepted solution]

i have used calendar to create the table.now i can use  datesbetween('sheet'[date],edate(max('sheet'[date]),-12)+1,max('sheet'[date]))  to avoid this problem. thank you.