Forum Discussion
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 (...
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
Thank you !!!
Great help