Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Proud to be a Super User!
Thank you !!!
Great help
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
Proud to be a Super User!