cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## Number of candidate who had 2 or more days in the last week interaction

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

1 ACCEPTED SOLUTION
Super User

@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))``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
Community Support

Hi, @Anonymous

You can try the following methods.

1. 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.

Super User

@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))``````

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors