Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello -
I am working with a data set that has transactional data. The file is overwritten daily with the sales from the previous day.
My date field is called [Event Date Time] and my transaction date field is called [Trans Date] I also have several buyer types, with the filed being names [Buyer Type Code] with those being called 'STH' 'Adult' etc...
What I want to be able to do is, in my stacked bar chart that has the different buyer type codes, build into the expression a condition that only references after a certain date.
Currently, my expression is : =SUM({$<promoCDE={"Adult"}>}[Net Sold Qty])
I would like to add a condition after that only allows data from after the [Trans Date] of 9/18.
Thank you
If Trans Date is formatted like 'M/D/YYYY', maybe like
=SUM({$<promoCDE={"Adult"}, [Trans Date]= {">=9/18/2015"}>} [Net Sold Qty])
If Trans Date is formatted like 'M/D/YYYY', maybe like
=SUM({$<promoCDE={"Adult"}, [Trans Date]= {">=9/18/2015"}>} [Net Sold Qty])