Forum Discussion

JimJim's avatar
JimJim
Icon for Responsive Resident rankResponsive Resident
2 years ago
Solved

Issue with DATESINPERIOD

Hi Guys, Firstly, I am sorry for the lack of test data or even a pbix file, I tried replicating the issue in a test report so that I could demonstrate it to you, but I can't replicate the issue.   ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    replace this piece of code with the following

    VAR __dates = 
        DATESINPERIOD('Time (previous months)'[CalendarDate],
        __selectedDate,
        -13,
        MONTH)

    to

    VAR __dates = 
        DATESBETWEEN('Time (previous months)'[CalendarDate]
        ,EDATE(__selectedDate,-13),__selectedDate)
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

replace this piece of code with the following

VAR __dates = 
        DATESINPERIOD('Time (previous months)'[CalendarDate],
        __selectedDate,
        -13,
        MONTH)

to

VAR __dates = 
        DATESBETWEEN('Time (previous months)'[CalendarDate]
        ,EDATE(__selectedDate,-13),__selectedDate)