Forum Discussion
USERELATIONSHIP problem with appended Query
I have items created and closed each month. This was working for years and then we appended data from a new source. Since appending the query, this measure is no longer working. My current relationsh...
Just to discard possible issues, is the date closed field in the appended table formatted as date type (it must be the same type as the date field in the Date Table)?
Try:
Count closed actions =
CALCULATE(COUNTROWS (EQMS Appended), USERELATIONSHIP(EQMS Appended [Date Closed], Date Table [Date]))