Why Datesinperiod returns future date

[Anonymous]

Hello everyone,

I have a question. When I use the Datesinperiod function, it always returns the future dates, is there any way to eliminate them? 

Here is my code 

CAPAs Opened MTD Measure = CALCULATE(COUNT('CAPAs Opened MTD'[CAPA PR ID]),

    DATESINPERIOD('Date Table'[Date],LASTDATE('Date Table'[Date]), -1, MONTH))

Thanks for helping me

[johnt75]

A properly formed date table will have dates until 31 December in the final year, which could be why you're getting dates in the future. If you want to restrict it to 1 month from today you could use DATESINPERIOD('Date'[Date], TODAY(), -1, MONTH)

[Anonymous]

Hi @johnt75, 

I can not use Today(), because I need to include all the previous dates. My ideal result is from last date of my data to today.  Is that possible?

[johnt75 · Accepted solution]

You could try DATESBETWEEN('Date'[Date], MAX('Fact  table'[Date]), TODAY())