Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Making a column = it self

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. 

2 REPLIES 2
Mariusz
Community Champion
Community Champion

Hi @Anonymous 

 

Can you create a data sample?

 

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski


a data sample?

 

Anonymous
Not applicable

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors