I have nothing on my fact table before Sep 2019, and nothing after November 2020. I’ve added a column to my date table:
DatesWithCases = AND(Dates[Date] <= MAX('SourceData'[createdatetime]),Dates[Date]>=MIN('SourceData'[createdatetime]))
I’ve confirmed on the data tab that the trues and falses are showing up correctly.
I have multiple date columns in my fact table, I’ve used USERELATIONSHIP() to indicate which relationship to use.
I’ve created a measure to calculate case performance which gives the correct numbers
SSAT (Closed Date) = CALCULATE(((([Top Boxes]-[Bottom Boxes])/[Rated Cases (Closed Date)])*100 +100),USERELATIONSHIP('SourceData'[ClosedDate],Dates[Date]),Dates[DatesWithCases]=TRUE())
Any time I visualize the data based on MonthInCalendar, the visual gives me Jan 2019 thru Dec 2022. What am I doing wrong here?