DATESINPERIOD bug

[Daniil]

Let's say we have the following date table:

Date = CALENDAR ( "2018-01-01", "2018-12-31" )

The following table should be empty, but it returns one row instead -- 1 January 2018:

DatesInPeriod Before = 
DATESINPERIOD (
    'Date'[Date],
    MIN ( 'Date'[Date] ) - 1,
    -1,
    MONTH 
)

The following table, which mirros the previous one, is empty as expected:

DatesInPeriod After = 
DATESINPERIOD (
    'Date'[Date],
    MAX ( 'Date'[Date] ) + 1,
    1,
    MONTH
)

DATESBETWEEN works as expected in both cases.

Download sample file: DatesInPeriod bug.pbix

[v-qiuyu-msft]

Hi @Daniil,

I have reported this issue internally: CRI 87906481. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @Daniil,

I got below information: 

We acknowledge this as a product defect, but since it is a corner case which isn't particularly useful we decided we won't make any investment in fixing this right now. If the user brings good arguments as to why this is critical for their scenario, please let us know and we will reconsider our decision.

Best Regards,
Qiuyun Yu