Forum Discussion
jpt1228
Responsive Resident
Responsive ResidentFilter Value based on the max date available
Hello, I typically try to exhast all the searches but I've been serching for a while and there are plenty of more complex examples but I can't get this figured out. I have a data model and have b...
from the description you posted, the date you want is in the customer table and the filter is on the date table. So try this
Measure = CALCULATE(SUM('Customer'[Dollars]), FILTER(ALL(DimDate[Date]) , DimDate[Date] = MAX(Customer[Date]))
MattAllington
Community Champion
Community Championfrom the description you posted, the date you want is in the customer table and the filter is on the date table. So try this
Measure = CALCULATE(SUM('Customer'[Dollars]), FILTER(ALL(DimDate[Date]) , DimDate[Date] = MAX(Customer[Date]))
