PREVIOUSMONTH in SUMMARIZECOLUMNS

[i_zharyi]

Hi!

i have measure for table 'sellout' [sellout_previuos_m] = 

ROUND(CALCULATE('sellout'[amount];ALL('calendar'[Month]);(PREVIOUSMONTH('calendar'[Date])));2)

in pivot table ir works fine.

and i want calculate table

SUMMARIZECOLUMNS(
        sellout[Branch],   sellout[Month],
        "p", [plan],
        "f", [forecast],
        "s0", [sellout_this_m],
        "s-1", [sellout_previuos_m ]
        )

but last column "s-1" calculated as BLANK()

what am i doing wrong?

[johnt75 · Accepted solution]

Remove the ALL('calendar'[Month])