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...
Use selected date in place of date[Date]
'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1 -7
Like
var _max =Maxx(Date, Date[Date])
var _ls_mon = _max+-1*WEEKDAY('Date'[Date],2)+1 -7
-7 for last week. Else do not use that
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")
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")