Display Data Label for very last data point in cumulative line

[Anonymous]

Hi team,

I have a cumulative line of Users login by day. i would like to show the data label at the end of the cumulative line. 

Is it possible and how can i do it.

Please help.

[v-gizhi-msft]

Hi,

Do you have issue about cumulative measure total?

If so, please try like this:

Cumulative = 
VAR a =
    ALLSELECTED ( 'Table' )
RETURN
    SUMX (
        DISTINCT ( 'Table'[Date] ),
        CALCULATE (
            CALCULATE (
                SUM ( 'Table'[Count_of_Users_Login] ),
                FILTER ( a, 'Table'[Date] <= MAX ( 'Table'[Date] ) )
            )
        )
    )

The result shows:

Hope this helps.

Best Regards,

Giotto

[Greg_Deckler]

Depends. Do you have an Index column or a Date/Time column that you can use to define "last" or "latest"?

If so, https://community.powerbi.com/t5/Quick-Measures-Gallery/Lookup-Min-Max/td-p/985814