Forum Discussion
Issues with EOMONTH
This formula: Assigned last year = CALCULATE([Case count], USERELATIONSHIP('calendar'[Dates],'All cases combined'[Date assigned]), DATESINPERIOD('All cases combined'[Date assigned], EOMONTH(T...
Try changing the DATESINPERIOD function to use the 'calendar'[Dates] column instead of the column from your data table