Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ryand009
Frequent Visitor

Dax Dates question

Hello

 

My date table (tblCalendar) is calculated between the min and max dates in another table. The Max date is 28/October/2022 (today). I created 2 measures , a YTD count and a ThisTimeLastYear count, but the ThisTimeLastYear is giving incorrect results, so I used the following DAX to return the dates … 

 

EVALUATE
VAR StartDate = DATE ( 2022, 01, 01 )
VAR EndDate = DATE ( 2022, 10, 28 )
RETURN
    CALCULATETABLE (
        DATEADD ( tblCalendar[Date], -1, YEAR ),
        tblCalendar[Date] >= StartDate &&
        tblCalendar[Date] <= EndDate
    )
ORDER BY [Date] DESC

 

If I use and EndDate of October 28 2022, it returns 3 additional dates October 29, 30 and 31, even though these dates are not in any table? All other dates I’ve tested return the expected range. January 2022 has the same structure as October 2022, i.e. Jan 1 /Oct 1 are Saturday and Jan 31 /Oct 31 are Monday, and the January results are as expected.

 

I’ve been looking at this for a couple of hours and I can’t figure any reason for the 3 extra dates?

 

Any ideas

 

Thanks in advance.

1 ACCEPTED SOLUTION
bcdobbs
Community Champion
Community Champion

Does your date table contain full years? Eg 1 Jan to 31 Dec? Also is it marked as a date table?

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

1 REPLY 1
bcdobbs
Community Champion
Community Champion

Does your date table contain full years? Eg 1 Jan to 31 Dec? Also is it marked as a date table?

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.