Need help to create custom column

[Anonymous]

Hi Team,

Could you please me to create custom column for below sample data:

Logic:  need to update the same status for duplicate domains based on latest notification date.

Example: Domain A, have duplicate records, based on latest date(13/8/2019) , need to create custom column(Result) to update the status.

[Anonymous · Accepted solution]

Hi @Anonymous,

You can write a variable to lookup the latest date based on current domain, then you can simply use current domain and latest date variable to find out the last status.

column =
VAR _lastdate =
    CALCULATE (
        MAX ( Table[Date] ),
        FILTER ( Table, [Domain] = EARLIER ( Table[Domain] ) )
    )
RETURN
    CALCULATE (
        MAX ( Table[Status] ),
        FILTER ( Table, [Domain] = EARLIER ( Table[Domain] ) && [Date] = _lastdate )
    )

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous 

try this

Column =

var max_date__=calculate(max('Table'[date]),ALLEXCEPT('Table','Table'[Domain]))

return

LOOKUPVALUE('Table'[Status],'Table'[Date],max_date__)

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.