Forum Discussion

LyncoData1's avatar
LyncoData1
Helper 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 so and I also do not want to use slicer. Any help would be appriciated!

 

Net Sales = SUM(FactNetSales[Amount])
 
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.

3 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community 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
      Helper 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
        Community 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.