Making a column = it self

[Anonymous]

I have no idea, if this is possible, but i have searched alot for answer without really finding any. 

Im sorry i cant post my file, but since its against company policy i will try to explain it as good as i can. 

Basically i want to see if a site is open on a specific date of this and last year. The way i was thinking was to check if there is any net sales on a date. 

So i have these columns: Basecat, Site.No, Date, Net Sales, Net Sales LY. 

The way i was thinking it should work is saying: =calculate(sum(Data[Net Sales]), Data[Site.no]=Data[Site.No], Data [Date]=Data[Date])

I have tried with and filter(earlier()), but it dosnt seem to sum it correctly. 

Hope someone can help me witht this. 

[Mariusz]

Hi @Anonymous 

Can you create a data sample?

Best Regards,
Mariusz

Please feel free to connect with me.

a data sample?

[Anonymous]

Hi @Mariusz 

It seems that i can't upload a file, but here is a screenshot of my sample, so in the column Closed TY and Closed LY i want it to sum up all the Net Sales from that day on one site. 

Hope it makes sense.