Forum Discussion

damtran's avatar
damtran
Regular Visitor
3 years ago
Solved

Indicate New vs Existing Customer

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 202...
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    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's avatar
damtran
Regular Visitor
3 years ago

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's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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's avatar
      damtran
      Regular Visitor
      3 years ago

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