PhoebeKNew Member4 years agoIssues 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...Show More
tamerj1Community Champion4 years agoHi PhoebeK You are utilizing an inactive relationship. Once I strangely faced an issue where the solution was to CROSSFILTER - None the active relationship. Worth nothing to try.
Related contentIssue with EOMONTH FunctionEomonth last dateAveragex issueEOMONTH equivalent in MRelationship Issue
