Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
@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))
Hi, @Anonymous
You can try the following methods.
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.
@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))
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |