Forum Discussion

LyncoData1's avatar
LyncoData1
Icon for Helper I rankHelper I
6 years ago
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...
Need Help
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    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.

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

LyncoData1 ,

 

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

 

Regards,

Jimmy Tao

LyncoData1's avatar
LyncoData1
Icon for Helper I rankHelper I
6 years ago

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's avatar
    v-yuta-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.