Variable issue

[risabhroy_03]

I am using the below variable in my measure and it works perfectly correct.

let vLastmonthdate2 =floor(num(Date(floor(monthend(addmonths(Today(),-1))))));

My measure is Sum({<DateBridgeFlag={'Inventory'},Company_Code={215,240},[Inventory Type]={'RM\BOP','RM\BOP-Arya'},[Table Source_Inventory]={'WHUIL200'},[Invoice_Date_GMT_Updated]={"$(vLastmonthdate2)"}>} Weight_Inventory)

But when I just put the value in place of variable, it is giving me wrong values

Sum({<DateBridgeFlag={'Inventory'},Company_Code={215,240},[Inventory Type]={'RM\BOP','RM\BOP-Arya'},[Table Source_Inventory]={'WHUIL200'},[Invoice_Date_GMT_Updated]={'=$(=(floor(num(Date(floor(monthend(addmonths(Today(),-1))))))))'}>}Weight_Inventory)

Can anyone please help me?

[marcus_sommer · Accepted solution]

Try it with:

let vLastmonthdate2 =floor(monthend(addmonths(Today(),-1)));

Sum({<DateBridgeFlag={'Inventory'},Company_Code={215,240},[Inventory Type]={'RM\BOP','RM\BOP-Arya'},[Table Source_Inventory]={'WHUIL200'},[Invoice_Date_GMT_Updated]={"$(=floor(monthend(addmonths(Today(),-1))))"}>}Weight_Inventory)

- Marcus