Get the last value by month in dax

Question

I have a table with registered values every day, I need a dax measure to get only the last value of the las day each month.

Original table

To see only this

Needed calculation

How can I solve it?

Answer 1

You can use this dax query to create a result table with last value of each month

Table = SUMMARIZECOLUMNS(Sheet1[Date], "last_value", LASTNONBLANK(Sheet1[Amount], 1))

See the screenshot with test data for reference:
Original table:

Result table:

Let me know if this is what you are looking for and if this solution works.