Measure to filter rows based on two dates (begin and end date)
Hi everyone, I have been working on this problem for a couple of hours now and hope someone is able to help me solve this: Looking to get a measure with Active verhicles (>=Purchase date , <=Replacement date). Measure should be able to get a graph with active number of verhicles per year 2007=number,2008=number,2009=number, etc. And used as a reportcard to say number of current active vehicles. My two tables The data model This is the dax I got so far, (Note how it will filter on purchase dates, and not on active between date) #Vehicles Active = COUNTX(FILTER(FleetActivity, FleetActivity[PurchaseDate]<= RELATED('Date'[Date]) && FleetActivity[ReplacementDate] >= RELATED('Date'[Date])), FleetActivity[ClassStructure]) I thank you for any help I can get
