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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

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

     

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

    Thanks Alex, that's great.