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...
If you have a Date table and in that Date table have a Weekday column created using WEEKDAY then you could do this:
Latest Monday = MAXX(FILTER('Date',[Weekday] = 2),[Date])
Assuming you use the WEEKDAY version that gives you 2 for Monday.