Need Help Writing a Dated Difference Formula

refer

https://community.powerbi.com/t5/Desktop/Using-earliest-and-latest-dates/td-p/574672

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

You can created calculated columns like these:

Earliest Date =
CALCULATE ( MIN ( Table[Sent Date] ), ALLEXCEPT ( Table, Table[Filename] ) )

Latest Date =
CALCULATE ( MAX ( Table[Sent Date] ), ALLEXCEPT ( Table, Table[Filename] ) )

And then create another column to get the difference.

Hi KarlConstruct ,

We can filter the rows of first date and the last date in power query editor if you need.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Zc67DcAgDEDBXVyDZPMNZcIYiP3XSAQNymuvujHkFidBrXk1r0Gm+1EkJVImlUXPSZV0kRrIlGSkve8nRVIiZVIhVdK3ny8=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Name = _t, Date = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", type text}, {"Date", type date}}),
    Test = Table.SelectRows(
                #"Changed Type",
                each let d = [Date],
                         n = [Name],
                         t = Table.SelectRows(#"Changed Type", each [Name]=n),
                         isMin = List.Contains(Table.ToList(Table.TransformColumnTypes(Table.SelectColumns(Record.ToTable(Table.Min(Table.SelectColumns(t,"Date"),"Date")),"Value"),{{"Value",type text}})),Date.ToText(d)),
                         isMax = List.Contains(Table.ToList(Table.TransformColumnTypes(Table.SelectColumns(Record.ToTable(Table.Max(Table.SelectColumns(t,"Date"),"Date")),"Value"),{{"Value",type text}})),Date.ToText(d))
                      in 
                        isMin or isMax
            )
in
    Test

The formula may need to do some change based on the type and name of columns.

BTW, pbix as attached.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi KarlConstruct ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,