I just want to ask about the issue I encountered I used this measurement
prev_total_cost = CALCULATE([m_total_cost], DATEADD(Date [REPORT_MONTH], -1, MONTH))
to fetch the previous month's value so that I can see the difference of my sales column. However, upon checking I noticed that for the month of June 2023 it doesn't show the value of May 2023 (please see attached image), supposedly it should show ($13497). Hope you can help me.
