Create new bool column depending on previous rows

[ABAXA]

I'm trying to create a new column named "Exists at least One time"

The output should be like shown in the table below.

I believe that the logic will be :

1- for each path, check how many occurence of the path in the table (AAAA = 3 times)

2- for each occurence, check the Exists column, if one is false "Exists a least One time" = FALSE else TRUE

How to implement this in power query or Power BI custom column ?

[Anonymous · Accepted solution]

Hi @ABAXA ，

Here I suggest you to try this code to create a custom column in Power Query.

if 
Table.RowCount(
let _path = [Path] in
Table.SelectRows(#"Changed Type",each [Path] = _path and [Exist] = true)) = 0 
then
"false"
else
"true"

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.