Question regarding DAX formula for calculation value previous month

[Jdelgard]

Hi. 

I have a created a measure that compares the inventory value this month with the previous month. But this value is blank when added to a visual. 

Previous Month =

CALCULATE(COMPACT_STORE_INVENTORY[Lift Inventory Value],

DATEADD(BC_Item[DWDate], -1,MONTH))

The lift Inventory value is also calculated with the following formula: 

Lift Inventory Value =

SUMX(

    SUMMARIZE(BC_Item,

    BC_Item[Unit_Cost],

    "Value", SUM(BC_Item[Inventory]) * BC_Item[Unit_Cost]

    ), [Value]

)

Any ideas why the Previous Month is blank?

Thanks in advance. 

[some_bih]

Hi @Jdelgard without model and details it is hard to spot issue. Still, try v2 for previous month. You should use some agg.function, like SUM, COUNT ... to use CALCULATE

Previous Month V2 =
CALCULATE(
SUM(COMPACT_STORE_INVENTORY[Lift Inventory Value]),
DATEADD(BC_Item[DWDate], -1,MONTH))