Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Find latest value (text + decimals) by date/timestamp

Hi! I have a bunch of records (events) coming from the Firebase. Each contains a device operation system version (e.g. Android 9, Android 11). So, I need to create a measure to show the latest OS ver...
Need Help
jppv20's avatar
jppv20
Icon for Solution Sage rankSolution Sage
5 years ago

Anonymous Could you provide some example data?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    • v-easonf-msft's avatar
      v-easonf-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, Anonymous 

      Try the following measures:

      os_num = 
VALUE ( MID ( MAX ( 'Table'[os] ), 9, 3 ) )
      Max(os) = 
CALCULATE (
    MAX ( 'Table'[os] ),
    FILTER (
        'Table',
        'Table'[name] = MAX ( 'Table'[name] )
            && 'Table'[device] = MAX ( 'Table'[device] )
            && [os_num]
                = MAXX ( ALLEXCEPT ( 'Table', 'Table'[name], 'Table'[device] ), [os_num] )
    )
)

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