Forum Discussion
Need Help writing a DAX Formula that returns distinct values based on max date
Hello everyone, i need your help in writing a DAX Formula that returns distinct values for a row, based on max date that is smaller or equal to the value chosen in a slicer. So i have a DataTabl...
tamerj1
Community Champion
Community ChampionHi CarMechanic
the date slicer is coming from a dimDate table?
yes
- tamerj1
Try by placing the following measure in the filter pane of the table visual and select "is" (1) then apply the filter
FilterMeasure =
INT (
MAX ( DataTable[Loadtime] )
= CALCULATE (
MAX ( DataTable[Loadtime] ),
ALLEXCEPT ( DataTable, DataTable[Name] ),
'Date'[Date] <= MAX ( 'Date'[Date] )
)
)