Forum Discussion

abdalla's avatar
abdalla
Helper I
4 years ago
Solved

display values with latest date on map

hello, I have a map with alot of points that i need to display the values of pressure that correlate to the latest active month date. This is how my data looks like i havent made any measure...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI abdalla,

    I'd like to suggest you write a formal with a variable to extract the last date based on the current Well field value.
    Then you can use the current Well and lastdate as conditions to find out corresponding pressure values:

    formual =
VAR _lastdate =
    CALCULATE (
        MAX ( Table[Active Month] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Well] )
    )
RETURN
    CALCULATE (
        MAX ( Table[Psi] ),
        FILTER ( ALLSELECTED ( Table ), Table[Active Month] = _lastdate ),
        VALUES ( Table[Well] )
    )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI abdalla,

I'd like to suggest you write a formal with a variable to extract the last date based on the current Well field value.
Then you can use the current Well and lastdate as conditions to find out corresponding pressure values:

formual =
VAR _lastdate =
    CALCULATE (
        MAX ( Table[Active Month] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Well] )
    )
RETURN
    CALCULATE (
        MAX ( Table[Psi] ),
        FILTER ( ALLSELECTED ( Table ), Table[Active Month] = _lastdate ),
        VALUES ( Table[Well] )
    )

Regards,

Xiaoxin Sheng