Forum Discussion
Solved
Join Calendar table on 2 dates
Hello Everyone, I'm trying to do a Histogram chart for my company like this : On this one, the dates comes from my calendar table. My data model looks like this : But now, I...
Hi Hugz02 ,
For this you need to do two relationships with the calendar table:
Date - Open Date
Date - Closed Date
One of this relationships will be inactive so for that one you need to use a USERELATIONSHIP to activate it let's assume that the open date is the active relationship then for the closed you would need to do the following measure:
Closed incidents = CALCULATE(COUNT(Table[Incident]), USERELATIONSHIP(Calendar[Date], Table[CloseDate]))
