Forum Discussion

SuzanneSte's avatar
SuzanneSte
Frequent Visitor
3 years ago
Solved

Assistance needed

Hello, I hope you can guide me on this problem.

I am attempting to count each instance an appoinmtent is created (Event Created date), but I need to exclude lines from the count if another element (invitees email address), is duplicated in the dataset. 

So firstly, I am trying to identify duplicates in the email addresses and store them in a created column

Having difficulty with that

 

 

 

Can you advise please 

 

Need Help
  • some_bih's avatar
    some_bih
    3 years ago

    Hi SuzanneSte  your RepEmailCol calculated column could be like below. Hope this help

    RepEmailCol=
    --Check_duplicate
    VAR _currentvalue='events-export'[Invitee Email]
    VAR _count_filtering=
    COUNTROWS(
    FILTER(
    'events-export',
    'events-export'[Invitee Email]=_currentvalue
    )
    )
    VAR _Result=
    IF(
    _count_filtering>1,
    "Duplicate",
    "Distinct"
    )
    RETURN _Result

2 Replies

  • some_bih's avatar
    some_bih
    Community Champion
    3 years ago

    Hi SuzanneSte  your RepEmailCol calculated column could be like below. Hope this help

    RepEmailCol=
    --Check_duplicate
    VAR _currentvalue='events-export'[Invitee Email]
    VAR _count_filtering=
    COUNTROWS(
    FILTER(
    'events-export',
    'events-export'[Invitee Email]=_currentvalue
    )
    )
    VAR _Result=
    IF(
    _count_filtering>1,
    "Duplicate",
    "Distinct"
    )
    RETURN _Result