Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
This is where I started from. I have straight table that gives current inventory value for each SKU.
I need to add new date dimension that doesn't exist for inventory data. When I add it, inventory value is 0 for each date dimension rows and there is a null field that has all the inventory in it. How can I replicate the inventory value for each sku rows so it ignores the required date field?
Expression is following:
sum({< [Inventory YearWeek] = {'$(=Max({1}[Inventory YearWeek]))'}, Year=,[Required Date]=,Date=, MonthName=, Month=, Quarter=, Week= ,[Item Type]-={'Service'} >} [Inventory Qty])
Try this:
Sum(TOTAL <SKU> {< [Inventory YearWeek] = {'$(=Max({1}[Inventory YearWeek]))'}, Year=,[Required Date]=,Date=, MonthName=, Month=, Quarter=, Week= ,[Item Type]-={'Service'} >} [Inventory Qty])
Try this:
Sum(TOTAL <SKU> {< [Inventory YearWeek] = {'$(=Max({1}[Inventory YearWeek]))'}, Year=,[Required Date]=,Date=, MonthName=, Month=, Quarter=, Week= ,[Item Type]-={'Service'} >} [Inventory Qty])