Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How to check duplicate values in a column1, create new adde column, if in case duplicate values present in the column1 display as well new added column ...
With out grouping, Is there any alternativies to fing the duplicates ?like IF condition like this,,
ex: i have tried somthing in statically : if ([Column1] <> "null") then Table.RowCount(Table.SelectRows(#"Changed Type5", each ([Column1] = "Bike"))) else ""
but is there in any altenativies.....
Ex :
hi @durgaraop21 try this
lst = List.Buffer(List.RemoveNulls(prev_step[Column1])),
next_step = Table.AddColumn(prev_step, "cnt", (x) => if x[Column1] = null then "" else List.Count(List.PositionOf(lst, x[Column1], Occurrence.All)))
Thanks for the reply, But not working above Logic, Use only Power query Editor only.....