need help to create measure Previous Month value

[Cardi0z]

Dear All,

need help to create measure for showing data about Previous Month value.
today i am trying create measure below :

pa_prev_month =

CALCULATE(

            SUM(PA[tot_prod]),

            PREVIOUSMONTH(PA[date_k].[Date])

        )


but, i am getting issue that value of previous month not calculated correctly

please help me

[mickey64 · Accepted solution]

For your reference.

Calculation = EXPANDALL(SUM([M_Prev Sum]),ROWS)

Using visual calculations in Power BI Desktop - Power BI | Microsoft Learn

[Idrissshatila]

Hello @Cardi0z ,

can you please explain why you're assuming the data is wrong, because in your screenshot the data looks matching for the previous month.