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