Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
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.