- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Frequent callers to call center
Hi
I have data where it has phone numbers, callID, Date like below, I would like to add new column if phone numbers are same and call Id is different and date is similar I would like to tag as called on same day , if phone number is same and call ID is different and date is diffent i would like to tag as per teh date difference called after 1day or 2days, if the phone numbers are same and call ID is same I dnt want to tag them.
phone number | CallID | Date | New Column |
123-456-789 | ABC | 15-sep-2022 | Called on same day |
123-456-789 | ABC | 15-sep-2022 | |
123-456-789 | XYZ | 15-sep-2022 | Called on same day |
123-456-789 | GHC | 16-sep-2022 | Called on next day |
789-123-456 | JKU | 18-sep-2022 | |
789-123-456 | YOU | 20-sep-2022 | called after 2days |
456-789-123 | HBJ | 20-sep-2022 | non repeat |
456-789-123 | HBJ | 20-sep-2022 | non repeat |
Please help me on this
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Anonymous
You need to sort the table and add an index column in PQ like:
Then try calculated column like:
Index1 = RANKX(FILTER(ALL('Table'),'Table'[phone number]=EARLIER('Table'[phone number])),'Table'[Index],,ASC,Dense)
Result =
VAR _mindate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALLEXCEPT ( 'Table', 'Table'[phone number] ), 'Table'[Index1] = 1 )
)
VAR _datediff =
DATEDIFF ( _mindate, 'Table'[Date], DAY )
RETURN
SWITCH (
TRUE (),
'Table'[Index1] = 1, BLANK (),
_datediff = 0, "Called on same day",
_datediff = 1, "Called on next day",
"Called after " & _datediff & " days"
)
Best Regards,
Community Support Team _ Eason

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thank you so much! It worked 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi, @Anonymous
You need to sort the table and add an index column in PQ like:
Then try calculated column like:
Index1 = RANKX(FILTER(ALL('Table'),'Table'[phone number]=EARLIER('Table'[phone number])),'Table'[Index],,ASC,Dense)
Result =
VAR _mindate =
CALCULATE (
MAX ( 'Table'[Date] ),
FILTER ( ALLEXCEPT ( 'Table', 'Table'[phone number] ), 'Table'[Index1] = 1 )
)
VAR _datediff =
DATEDIFF ( _mindate, 'Table'[Date], DAY )
RETURN
SWITCH (
TRUE (),
'Table'[Index1] = 1, BLANK (),
_datediff = 0, "Called on same day",
_datediff = 1, "Called on next day",
"Called after " & _datediff & " days"
)
Best Regards,
Community Support Team _ Eason

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
05-24-2025 01:58 PM | |||
02-27-2018 08:31 AM | |||
01-21-2022 12:42 AM | |||
02-06-2025 11:53 PM | |||
09-28-2020 08:52 AM |
User | Count |
---|---|
57 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
79 | |
66 | |
45 | |
44 | |
42 |