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...
Hi amitchandak
I tried below
Unfortunately it didn't give required result.
I would like it 'Yes' if they have been contacted since the latest monday. So today is monday so it would only be yes for those contacted today.
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")