Calculating sales for last month

[gumis_rulez]

I am struggling with achieving the result as below. I would like to add a measure which calculates the total sales for last month with sales (in this case may 1998) and add it to a line chart to mark as dot.

how to achieve this?

https://drive.google.com/file/d/1sChEISntbQP49N1fx_5GAJWfLhv4SPCv/view?usp=sharing 

[v-kaiyue-msft · Accepted solution]

Hi @gumis_rulez ,

You can try setting it up here:

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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