Net Sales Start from Yesterday

[LyncoData1]

Hello, I am trying to calculate Sales but I do not want to pull sales from current day. I want to start pulling all sales from prior day on back. I do not know how to manipulate NetSales meaure to do so and I also do not want to use slicer. Any help would be appriciated!

Net Sales = SUM(FactNetSales[Amount])

[v-yuta-msft]

@LyncoData1 ,

Could you please share some sample data and clarify more details about your requirement?

Regards,

Jimmy Tao

[LyncoData1]

I would like my Net Sales to start calculating from yesterday. From the 26th not the 27th. I am not sure what function to use in order to make this happen. I want to exclude current date going forward so my data wil auto populate to correct sales value.

[v-yuta-msft · Accepted solution]

@LyncoData1 ,

You may modify the measure like pattern below:

Net Sales =
CALCULATE (
    SUM ( 'FactNetSales'[Amount] ),
    FILTER ( 'FactNetSales', 'FactNetSales'[Year] < TODAY () )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.