Forum Discussion

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

This year date filter

Hiya,   I've made a filter to measure all the opportunities we've "won" this year as follows: Calculate( SUM('3. Opportunities'[Estimated Value]), '3. Opportunities'[Close Date - Copy] >= DATE(...
Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    LauraCawdronDav,

     

    Try this measure:

     

    Opportunities Won =
CALCULATE (
    SUM ( '3. Opportunities'[Estimated Value] ),
    '3. Opportunities'[Close Date - Copy] >= DATE ( YEAR ( TODAY () ), 1, 1 ),
    '3. Opportunities'[Status: won, lost, open] = "Won"
)
DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
3 years ago

LauraCawdronDav,

 

Try this measure:

 

Opportunities Won =
CALCULATE (
    SUM ( '3. Opportunities'[Estimated Value] ),
    '3. Opportunities'[Close Date - Copy] >= DATE ( YEAR ( TODAY () ), 1, 1 ),
    '3. Opportunities'[Status: won, lost, open] = "Won"
)