Hi - Currently i am currently calcualting WOS = (Latest week Shipment)/(13Week avgshipments) my week is between Monday to Sunday,, if i refresh the file on Wednesday the latest week shipment will be incomplete. so i have choose the previous completed week to do the calcualtion.
For a more complete answer, please provide sample data and/or screenshots of the data and your model.
Quick down and dirty method: create a calculated column in your date table for all weeks showing whether the week number is less than the current/incomplete week. This column will change every time the data is refreshed and use it as a flag to exclude dates in or after the current week number.
Is Weeknum less =
Var Thisweek = WEEKNUM(TODAY(),2)
IF([WeekNumber]<Thisweek, 1, 0)
Calculate([WOS], [Is Weeknum less] = 1)
Did I answer your question? Mark my post as a solution!
Without sample data, this is still just guessing. Please provide sample data and/or screenshots if available. Try this. Keep your latest_week_Inventory measure, add my LatestWeekInventory measure, and create the NewWoS_ST_new measure. don't remove your existing measures, just add my two versions and see if the NewWoS_ST_new works for you.