Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
6 years ago

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' [CandidateRef] ='Merge1'[CandidateRef]
&& 'Export Actions'[ActionName] = "Call - Update" && 'Export Actions'[ActionDate]>= date(2020,03,01)),
'Export Actions' [CandidateRef])),"No","Yes")
 
 
Thank you
Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    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.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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's avatar
      HenryJS
      Post Prodigy
      6 years ago

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