Cant get Max date

[drewP76]

Hello,

I'm new, tips are appreciated, thanks.

I want to return the most recent date for each computer in my data set.  My data set is from multiple CSV files in a folder (all CSV files are formated the same).  The formula I am using is returning the most recent date for each computer in each CSV file (which I dont want).  For example ( [Last Updated] is my calculated column )

FileName---------	Computer	Updated-------	Last Updated---
06-01-2020.csv	A	05-15-2020	05-15-2020
06-01-2020.csv	A	03-21-2020	05-15-2020
06-01-2020.csv	B	03-20-2020	03-20-2020
06-01-2020.csv	C	03-19-2020	03-19-2020
04-30-2020.csv	A	03-21-2020	03-21-2020

Above

• I want the red date to = 05-15-2020
• [FileName] is a column that PowerBI created for me (I like it being there and want to keep it), this column is not in my CSV files

I dont know how to get the filter to ignore the [FileName] column.  My formula:

Last Updated = 
VAR CurrentComputer = [Computer]
RETURN
MAXX(
  Filter (
    All (MyCsvCollection),
    MyCsvCollection[Computer] = CurrentComputer
  ),
  [Updated]
)

I have also:

• Added a new Calendar table, set it as a date table
• Created relationships (Calendar[Date] --> MyCsvCollection[Updated])

But I'm missing something.  I feel I'm close.  Any tips??

[mahoneypat]

Please try this column expression

Last Update = CALCULATE(MAX(MyCSVCollection[Updated]), ALLEXCEPT(MyCSVCollection, MyCSVCollection[Computer]))

Regards,

Pat