Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
In PowerQuery I want to add a custom column that evaluates how often a value exists and create a custom column based on the value
For example, new custom column(No of Rows) should be created based on how many times value exist in Column1 and if it is greater than 1 it should display as Yes or No in the column Result Column The below screen shot is what I'm trying to create
I dont want to create any group/summarized table
Solved! Go to Solution.
Hi,
Here you go:
Count occunrences (#"Changed Type" is the previous step):
= Table.AddColumn(#"Changed Type", "Custom", each List.Count(
Table.SelectRows(
#"Changed Type",
(A) => [Column1] = A[Column1]
)[Column1]
))
Test if over 1:
= Table.AddColumn(#"Added Custom", "Custom.1", each if [Column1] > 1 then "YES" else "NO")
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!
Thanks for your response . This perfectly worked for what I am trying to achieve .
Hi,
Here you go:
Count occunrences (#"Changed Type" is the previous step):
= Table.AddColumn(#"Changed Type", "Custom", each List.Count(
Table.SelectRows(
#"Changed Type",
(A) => [Column1] = A[Column1]
)[Column1]
))
Test if over 1:
= Table.AddColumn(#"Added Custom", "Custom.1", each if [Column1] > 1 then "YES" else "NO")
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
Proud to be a Super User!