Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
6 years ago

Checking if right code was deleted

Hi, need some help and hopefully this makes sense. I have 2 different tables below. The first table is the data. The second table tells you the combination of codes that cannot exist together for the...
Need Help
mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

I didn't make the index column with DAX.  I did it in the query editor using the button on the Add Column tab.  Here is the M code, but it is just simple index column addition.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUXLOT0k1BNL+RZnpmXmJOUCmEQgoxeqgKnBJzUktSQUyUGSMULUagwBYgRN2s01AAEMBqtlO2M02BAGl2FgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [ID = _t, Item = _t, Operation = _t, Data = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", type text}, {"Item", type text}, {"Operation", type text}, {"Data", Int64.Type}}),
    #"Added Index" = Table.AddIndexColumn(#"Changed Type", "Index", 1, 1)
in
    #"Added Index"

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

PowerBI123456's avatar
PowerBI123456
Post Partisan
6 years ago

mahoneypat  Hi - sorry for the delayed response, but is your code taking into the account the operation? For example, I want to look at deleted.