Straight table, same value for each SKU

[#1]

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])

[sunny_talwar · Accepted solution]

Try this:

Sum(TOTAL <SKU> {< [Inventory YearWeek] = {'$(=Max({1}[Inventory YearWeek]))'}, Year=,[Required Date]=,Date=, MonthName=, Month=, Quarter=, Week= ,[Item Type]-={'Service'} >} [Inventory Qty])