Add a column check if the project existed last year

[AnthonyJoseph]

Hi Community,

I have a dataset similar to the below, I need to create a column which can return True if the same combination of portfolio and project has existed (could be either active/yet to start/completed) last year, if not it should return false. I am not sure if this is achieveable in power query-please can someone help me on this.

Thanks,

AnthonyJoseph

[BA_Pete]

Hi AnthonyJoseph,

Group your table on [Portfolio] and [Project].

In the Group By dialog, add one aggregation column that uses the 'Count Rows' operator.

Add another that uses the 'All Rows' operator.

Exit the Group By dialog and add a new custom column like this:

if [countColumn] > 1 then "TRUE" else "FALSE"

Now expand your 'All Rows' column back out again to reinstate your original table.

Pete