Column = Latest Monday Function

[HenryJS]

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' [CandidateRef] ='Merge1'[CandidateRef]

&& 'Export Actions'[ActionName] = "Call - Update" && 'Export Actions'[ActionDate]>= date(2020,03,01)),

'Export Actions' [CandidateRef])),"No","Yes")

Thank you

[amitchandak]

@HenryJS 

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

[HenryJS]

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")

[amitchandak]

@HenryJS,Can you share sample data and sample output.

[HenryJS]

@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")

[HenryJS]

@Greg_Deckler @amitchandak is this possible to do without a Date Table?

Thanks

[Greg_Deckler]

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.