Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Need help to create custom column

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, ha...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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