Forum Discussion

Sannat's avatar
Sannat
Icon for Helper I rankHelper I
3 years ago
Solved

SUM or SUMX with start date value

I'm sure this will be straight forward, can someone tell me to add a start date to a SUM or SUMX measure please?  I'm calculating total sales from 1st August 2023.  I can find 'dates between' but not with just a start from.

 

My date table is 'Dates FY'

 

Many thanks in advance.

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    CALCULATE( SUM( 'Sales'[Column name]), 'sales'[date column] >= 01/08/2023)

     

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    CALCULATE( SUM( 'Sales'[Column name]), 'sales'[date column] >= 01/08/2023)

     

  • Sannat's avatar
    Sannat
    Icon for Helper I rankHelper I
    3 years ago

    I've found this isn't filtering my dates, is there anything else it might be?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Is your actual closed date data in date format?