Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |