Received working answer from "Will Kong" TechNet:
create table tblProjectSnapshot
(
[ProjectUniqueID] varchar(30),
[SnapshotDate] date,
[SnapshotID] int,
[ProjectName] varchar(64),
[Status] varchar(64)
)
insert into tblProjectSnapshot values
('A','1/1/2020',1,'Orange','Open'),
('B','1/1/2020',2,'Apple','Open'),
('C','1/1/2020',3,'Carrot','In Progress'),
('A','2/1/2020',1,'Orange','Open'),
('B','2/1/2020',2,'Apple','Closed'),
('C','2/1/2020',3,'Carrot','In Progress')
GO
create table tblMilestoneSnapshot
(
[SnapshotDate] date,
[SnapshotID] int,
[ProjectName] varchar(64),
[MilestoneS