How get only one Value via QA

[Davidkm]

Hi,
I need to add a year to the text box and I don't know how to enter to get the value of the year with the help of QA Is there a trick?

In this example I need get only number  2020

Thanks

[v-lionel-msft · Accepted solution]

Hi @Davidkm ,

Like this?

If the visual object you want is the following, you need to create measures.

__Count = 
VAR x = COUNTX( FILTER( ALL('Table'), [Year] = MAX([Year]) ), [Order] )
RETURN
x

__Year = 
VAR x =  
MAXX(
    ALL('Table'),
    [__Count]
)
RETURN
CALCULATE(
    MAX([Year]),
    FILTER(
        'Table',
        [__Count] = x
    )
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.