Previous Month on Calculated Column

Hi, You could create a calculated table with this measure: Table = SUMMARIZECOLUMNS(Table1[id]; "201809";CALCULATE(SUM(Table1[import]);MONTH('Date'[Date])=08); "201810";CALCULATE(SUM(Table1[import]);MONTH('Date'[Date])=09); "201811";CALCULATE(SUM(Table1[import]);MONTH('Date'[Date])=10); "201812";CALCULATE(SUM(Table1[import]);MONTH('Date'[Date])=11) )

Hi Anonymous,

 

By my tests, the formula from Chiara should be helpful.

 

You also could create an index calculated column and a measure to achieve that.

 

Index = 
RANKX (
    FILTER (
        'Table2',
        EARLIER ( 'Table2'[id] ) = 'Table2'[id]
    ),
    [date],
    ,
    ASC
)

Measure =
VAR a =
    CALCULATE (
        MAX ( Table2[import] ),
        FILTER (
            ALLEXCEPT ( 'Table2', Table2[id] ),
            'Table2'[Index]
                = MAX ( 'Table2'[Index] ) - 1
        )
    )
RETURN
    IF ( a = BLANK (), "Na", a )

 

Best Regards,

Cherry