- 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
take data of selected month
Hello I have mobile number reflecting multiple times in different month , i want to have counts of duplication of mobile number of selected month
for eg if i select Jan 23 it should show counts only for jan Jan23
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous
Please try
=
SUMX (
VALUES ( 'Table'[phone] ),
VAR CountDuplicate =
COUNTROWS ( CALCULATETABLE ( 'Table' ) )
RETURN
IF ( CountDuplicate = 2, CountDuplicate )
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Anonymous
Please try
=
SUMX (
VALUES ( 'Table'[phone] ),
VAR CountDuplicate =
COUNTROWS ( CALCULATETABLE ( 'Table' ) )
RETURN
IF ( CountDuplicate = 2, CountDuplicate )
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thak you for your help @tamerj1 ,addition to this i want to show duplication in next 90 days ,what will be the measure for that ,for eg, if i select april , i want to show duplication in april may and june
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
Do you have a date table?
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
08-12-2024 10:56 AM | |||
06-30-2024 07:34 AM | |||
03-23-2024 12:23 AM | |||
12-13-2023 09:54 AM | |||
04-23-2024 09:19 AM |
User | Count |
---|---|
21 | |
18 | |
17 | |
7 | |
5 |
User | Count |
---|---|
32 | |
27 | |
19 | |
13 | |
12 |