Forum Discussion
Solved
Net Sales Start from Yesterday
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...
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.
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.
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.