Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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. 

Need Help

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Can you create a data sample?

     

    Best Regards,
    Mariusz

    Please feel free to connect with me.
    Mariusz Repczynski


    a data sample?

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.