Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.....
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.