How to deal with those value without date in Visual

[naoyixue1]

Hey all,

I created a table to highlight the this week ending inventory, total demand , total supply and the running total Inventory, with the time lookup table. (see below)

Now there is some value attached to no Month Year, which lowers my each week running total inventory by 4,187,308 units. Is there any way for us to remove the value for those rows without year and month. In this case, there should be no ending inv, demand, supply and running total inventoy till 2023-10. Any thoughts? Thanks! 

[amitchandak]

@naoyixue1 , Null in means, Date is null in Table.

Date are not available in common date table

Date joined with date table's Date has timestap

You can remove it using visual level filter and check date is not blank

[naoyixue1]

@amitchandak THanks, but that didn't solve the issue, since the calculation is still behind the scenes.

Filter blank date before

FIlter blank date after

Even after I hided the months we don't have supply and demand (from 2023-01 to 2023-09), still doesn't work. I remember there is a way to handle that. But anyway thanks.