Indicate New vs Existing Customer

[damtran]

Hi everyone,

I'd like to ask for help in this case:

- Table has 3 columns: Customer, Revenue, and Year

- Some customers have revenue in both 2022 and 2023 = Existing, some just have revenue in 2023 = New

Could you please advise how to create a new column with measure which can tell Existing or New based on customer name, revenue and year?

Thanks in advance.

[damtran]

Hi @FreemanZ ,

Thank you very much for your prompt support, may I ask more if in column Customer, Customer name repeats in many rows within one year, how to modify these DAX? As now, I input same way and all tells it's Old Customer. Thanks in advanced. Here is the data example:

[FreemanZ · Accepted solution]

hi @damtran 

try to replace:

COUNTROWS(

    FILTER(

       _table,

        TableName[Year] = _currentyear

    )

)

with:

COUNTROWS(

    CALCULATETABLE(

       SUMMARIZE(_table, TableName[ClientID])

        TableName[Year] = _currentyear

    )

)

other parts are similar.

[damtran]

Thank you so much @FreemanZ , you help me save a lot of time!!!!!!!!!!

[FreemanZ]

hi @damtran 

This is almost identical to another post yesterday. please refer to my reply in this post:

https://community.powerbi.com/t5/Desktop/Determine-if-the-value-occurs-more-than-once-in-the-column/...