Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Number of candidate who had 2 or more days in the last week interaction
11-08-2021
07:18 AM
I have a table
I want to know how many candidate have 2 or more days in the last week interaction from the table above.
How do i get this in dax
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2021
08:25 AM
@Anonymous Try:
Measure =
VAR __MaxDate = TODAY()
VAR __MinDate = __MaxDate - 7
VAR __Table = SUMMARIZE(FILTER('Table',[Date]<=__MaxDAte && [Date]>=__MinDate),[Candidate],"__Count",COUNTROWS('Table'))
RETURN
COUNTROWS(FILTER(__Table,[__Count]>=2))
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-10-2021
06:06 PM
Hi, @Anonymous
You can try the following methods.
- First calculate the number of days each candidate interacts.
Days =
CALCULATE (
MAX ( 'Table'[Date] ) - MIN ( 'Table'[Date] ),
FILTER ( 'Table', 'Table'[Candidate] = EARLIER ( 'Table'[Candidate] ) )
)
2. Use the measure to determine who is more than 2 days old.
Measure =
IF ( MAX ( 'Table'[Days] ) >= 2, 1, BLANK() )
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-08-2021
08:25 AM
@Anonymous Try:
Measure =
VAR __MaxDate = TODAY()
VAR __MinDate = __MaxDate - 7
VAR __Table = SUMMARIZE(FILTER('Table',[Date]<=__MaxDAte && [Date]>=__MinDate),[Candidate],"__Count",COUNTROWS('Table'))
RETURN
COUNTROWS(FILTER(__Table,[__Count]>=2))
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Announcements
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.
Recommendations
Subject | Author | Posted | |
---|---|---|---|
04-14-2024 07:24 AM | |||
06-07-2023 04:29 AM | |||
05-21-2024 07:42 AM | |||
04-17-2018 08:05 AM | |||
Anonymous
| 01-13-2020 10:05 PM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
127 | |
81 | |
59 | |
59 | |
44 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
182 | |
114 | |
82 | |
67 | |
52 |