Forum Discussion
Column = Latest Monday Function
Hi all, How can I ammend the below column to filter for >= Latest Monday Instead of 01.03.20? Contacted After March? = if(isblank(maxx(filter('Export Actions','Export Actions' [Candidate...
HenryJS,Can you share sample data and sample output.
amitchandak unfortunately I can't share the data as it's all personal and contact info!
I've got a measure in a different report that uses the 'LatestMonday' logic.
The below is a column granted but need:
- IF CandidateRef in 'Merge1' has had 'Export Actions'[ActionName] = Call Update
- Since 'Latest Monday'
- THEN Yes
Contacted Since Monday? = if(isblank(maxx(filter('Export Actions','Export Actions' [CandidateRef] ='Merge1'[CandidateRef]
&& 'Export Actions'[ActionName] = "Call - Update" && 'Export Actions'[ActionDate]>= 'Export Actions'[ActionDate]+-1*WEEKDAY('Export Actions'[ActionDate],2)+1-7),
'Export Actions' [CandidateRef])),"No","Yes")