Percentage Difference reference previous Date and Attribute

This can help...

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jdHBasMwDIDhVxk5F8WWLFs+bmPsIUoPg+YQ2FLWZn3+mcBgrmzH4IMOP/IHOh4HsqPFEQ2a4TC8ff/M6zzd0og+EngKw+nwEL1f7tN1+ZqW9enlspy3mC1E1unrdTrPaxrIEETUwfPnmnZ9rPN9+9R6dgRMW2jsmF4KbUOWRW1Zlj7ITCFp2rDHhv023Ldhr416bNRvo30b9dpczRYIpBQVbQgkOs1tAaNOmjau2UQAsRBVbM7pNLORQa+Tps1XbCGt88bqqHJThzr9Z0tHd6KLJi3UaCQQgtVRkWaARacZjSNHnTRtUrOxgP27k+zbPOo0t3EoJFXb6Rc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Attribute = _t, Value = _t]),
    ChangedType = Table.TransformColumnTypes(Source,{{"Value", type number}}),
    DateLocale = Table.TransformColumnTypes(ChangedType, {{"Date", type date}}, "hr-HR"),
    Custom1 = Table.AddIndexColumn(DateLocale, "Index",0,1),
    Grouped = Table.Group(Custom1, {"Attribute"}, {{"Gr", each let t=Table.AddIndexColumn( Table.Sort( _ , {"Date", Order.Ascending}), "Index2",-1,1) in Table.AddColumn( t, "Percent", each try ([Value] - t[Value]{[Index2]})/[Value] otherwise 0 ) , type table }}),
    Removed = Table.RemoveColumns(Grouped,{"Attribute"}),
    Expanded = Table.ExpandTableColumn(Removed, "Gr", {"Date", "Attribute", "Value", "Index", "Index2", "Percent"}, {"Date", "Attribute", "Value", "Index", "Index2", "Percent"}),
    #"Changed Type" = Table.TransformColumnTypes(Expanded,{{"Percent", Percentage.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Index", Order.Ascending}}),
    #"Removed Columns" = Table.RemoveColumns(#"Sorted Rows",{"Index", "Index2"})
in
    #"Removed Columns"

Hi danakajoel ,

Power Query method:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("jdHBagMhEIDhVyl7DrM64+h4bEPoQ4QcCtnDQruhic3zVwILdcxW8SL4M34wx+OABs1ocSQ77IbD98+c5umWr+gjgacwnHYqer/cp+vyNS3p5e2ynB8xW4hcp/vrdJ5TvpAhiFgHr58pz/pI8/3xqfXsCJjW0I75/O9ak6ZqDZXJVEGHCdsm7DVhy4R9JmqbqNdELRP1mZw2BQKpk6cmBBIdlqaAUQcdJtYmEUCskg2TczosTGTQ66DD5JUp5FHeWJ1s7M6hDv+Y8mqd6PcOUtAkEgjB6uQpyQCLDgsSR4466DCJNrGALTci2yaPOixNHKpg03T6BQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Date = _t, Attribute = _t, Value = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", type date}, {"Attribute", type text}, {"Value", type number}}),
    #"Grouped Rows" = 
        Table.Group(
            #"Changed Type", {"Attribute"}, 
                {
                    {
                        "Data", each 
                        let tab = Table.AddIndexColumn(_,"Index",1,1,Int64.Type) in 
                            Table.AddColumn(
                                tab, "New",
                                (x)=> try Table.Max(Table.SelectRows(tab,(y)=>y[Index]=x[Index]-1),"Index")[Value]
                                    otherwise null 
                            )
                    }
                }
        ),
    #"Expanded Data" = Table.ExpandTableColumn(#"Grouped Rows", "Data", {"Date", "Attribute", "Value", "New"}, {"Data.Date", "Data.Attribute", "Data.Value", "Data.New"}),
    #"Added Custom" = Table.AddColumn(#"Expanded Data", "Percent", each if [Data.New] = null then null else 
[Data.Value] / [Data.New] - 1),
    #"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Attribute", "Data.New"}),
    #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Data.Date", "Date"}, {"Data.Attribute", "Attribute"}, {"Data.Value", "Value"}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}, {"Attribute", type text}, {"Value", type number}, {"Percent", Percentage.Type}}),
    #"Sorted Rows" = Table.Sort(#"Changed Type1",{{"Date", Order.Ascending}})
in
    #"Sorted Rows"

Dax method:

Dax percent = 
VAR _d = [Date]
VAR _a = [Attribute]
VAR pre =
    CALCULATE (
        MAX ( 'Table'[Value] ),
        FILTER (
            ALL ( 'Table' ),
            'Table'[Attribute] = _a
                && 'Table'[Date]
                    = CALCULATE (
                        MAX ( 'Table'[Date] ),
                        FILTER ( ALL ( 'Table' ), 'Table'[Attribute] = _a && 'Table'[Date] < _d )
                    )
        )
    )
RETURN
    IF ( ISBLANK ( pre ), BLANK (), [Value] / pre - 1 )

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