Checking if a Column Changed from Last Month to This Month

Question

Good day,I am trying to see if there is a function that I can use to track if the record of same account number had changed over time. I am looking if I can add an extra column and if there is a change says "Yes" and if there is non says "No". the record of the time has more months, but I had filter the months into the first two months.&nbsp;Below is an example of my matrix table.&nbsp;Account NumberThe End of Last MonthToday1IncreaseIncrease2Decrease&nbsp;3Non ChangeNon Change*There is a possibility of blank if the account is close.&nbsp;Appreciate for any help.

vijay_a_verma · Accepted Answer

Here is one way
let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUfLMSy5KTSxOxclUitWJVjICMlxS4WKJSckgGaikMZDhl5+n4JyRmJeeis4Bq4oFAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Account Number" = _t, #"The End of Last Month" = _t, Today = _t, ColA = _t, ColB = _t]),
    #"Replaced Value" = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"Account Number", "The End of Last Month", "Today", "ColA", "ColB"}),
    #"Added Custom" = Table.AddColumn(#"Replaced Value", "Change", each [a = List.RemoveNulls(List.Skip(Record.ToList(_))),
 b = if List.MatchesAll(a, each _=a{0}) then "Yes" else "No"][b])
in
    #"Added Custom"

Forum Discussion

Checking if a Column Changed from Last Month to This Month

1 Reply

Related content

Check column for similar values

Column format check

check if columns are blank/null

Check is Fabric

Disable Spell Check

Account Number	The End of Last Month	Today
1	Increase	Increase
2	Decrease
3	Non Change	Non Change