Here is a little context. I have product subcategory as row label. I have a daily snapshot of inventory and using count of inventory as the measure. The measure I want to be sure that I return the latest dated inventory when I don't specify a date as the column label. But if a date is specified then I want to be sure to show that dates inventory in which the cell relates. Inventory from day to day can go to 0. So not everyday a subcategory has inventory. I have tried using LastNonEmpty to return the last date. But what happens is one subcategory is from today and the next subcategory is from the previous day that did have inventory for that date. I have been able to create a measure that returns the max date for which the column pertains. Here is that formula. CALCULATE(MAX([Business Date]), ALLEXCEPT('Inventory', 'Date'))
What I cannot seem to figure out is how to put that into the filter context for the inventory count so I return inventory which only pertains to that date. Any and all help is appreciated!
What I cannot seem to figure out is how to put that into the filter context for the inventory count so I return inventory which only pertains to that date. Any and all help is appreciated!
