Count of number of times value is present and create a custom column

[Anonymous]

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

[Anonymous]

Thanks for your response . This perfectly worked for what I am trying to achieve . 

[ValtteriN · Accepted 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!

[Anonymus_18]

• Hello @ValtteriN,could you tell how to modify the dax to check if we need the count the rows  for last 3 months from that row's date.?