Measure: Text & Date

Hi HenryJS 

Check if this result is ok.

To get this, I create a date table

date table =
ADDCOLUMNS (
    CALENDARAUTO (),
    "year", YEAR ( [Date] ),
    "month", MONTH ( [Date] ),
    "week", WEEKNUM (
        [Date],
        2
    ),
    "weekday", WEEKDAY (
        [Date],
        2
    )
)

Then Create measures

name =
LOOKUPVALUE (
    'Export Candidates'[Candidate Name],
    'Export Candidates'[CandidateRef], MAX ( 'Export Actions'[CandidateRef] )
)

lastMonday =
CALCULATE (
    MAX ( 'date table'[Date] ),
    FILTER (
        ALL ( 'date table' ),
        'date table'[weekday] = 1
            && 'date table'[Date]
                <= TODAY ()
    )
)


Contacted Since Monday =
IF (
    [name]
        <> BLANK ()
        && MAX ( [action.date] ) <= [lastMonday]
        && MAX ( [ActionName] ) = "Call - Update",
    "Yes",
    "No"
)

Contact By = IF([Contacted Since Monday]="Yes",MAX([UserName]))

Contacted on = IF([Contacted Since Monday]="Yes",MAX([ActionDate]))

[action.date] is a calculated column

action.date = [ActionDate].[Date]

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.