How will this prevent data from transfering to the previous day. Does this freeze previous day information. that way the data is a true trend
I think the requirement is to freeze previous day data at 12:00 am.
This has to be done at data-source level since Tableau will reflect as per Data source
Or if you have any columns like Last Update Date + you are adding subsequent records instead of overriding then it might be possible.
Can you share the excel sheet ? That will be helpful