Show data only up to the last week of actuals vs forecast

[John_V12]

Hi,

I have a column that differentiates between "Original Estimate" , "Updated Estimate" and "Actuals"

and then another column which give me the Quantity.

I do not have dates in the data, only week numbers.

I have a matrix as below, and what I want to achieve is to only show the data up to week 33 and then subsequent weeks as the data populates.

How will I achieve this?

Thank you,

[amitchandak · Accepted solution]

@John_V12 , best is use visual level filter Actual is not blank

else you have to rewrite a measure as

//Assuming original estimate is measure

original estimate new = sumx(filter(values(Table[Weel) , not(isblank[Actual] )) ), [original estimate] )