topic Help in DAX Commands and Tips

Help

Nihed — Thu, 17 Mar 2022 03:21:47 GMT

Hello,

Someone can help me please, how I can add number of the latest value at the end of the chart ?

as I showed in the picture:

Thank you

amitchandak — Thu, 17 Mar 2022 04:42:18 GMT

Nihed , refer if this can help

Anonymous — Mon, 21 Mar 2022 08:03:51 GMT

From what I understand, you only want to show the data labels for the last month's value in the line chart, right?

Please create a measure:

Measure = var _maxMonth= MAXX(ALL('Table'),MONTH([Date])) return CALCULATE(SUM('Table'[Value]),FILTER('Table',MONTH([Date])=_maxMonth))

And apply it to Values field as well, then enable the Customize series option as the blog provided by amitchandak mentioned:

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