Looking for Last Value for each

Hi PaulPalkowski ,

You can create a column as follows:

Is most recent =
var thisSite = tablename[Site]
var thisArea = tablename[Area]
var mostRecentDate = CALCULATE(MAX(tablename[Date]),FILTER(ALL(tablename), tablename[Site] = thisSite && tablename[Area] = thisArea))
return
IF(tablename[Date] = mostRecentDate,"yes","no")

The above DAX will return a column with YES/NO value based on most recent record at Site and Area level. Move this column to your table visual and select "yes". This will just display recent record in the table for a combination of Site and Area.

You can modify the above code as just SITE level or AREA level also.

Replace the right table name and column name in the above dax provided.

Thanks,

Pragati