Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Sum filtering minimum date (DAX)

Hello, I have a question about how to get a sum by filtering the minimum date of a field.  Follow example I have two tables (Calendar & Values),  Today I am filtering the "Date" field that is f...
Need Help
  • ElenaN's avatar
    ElenaN
    7 years ago

    Hello,

     

    You can try this:

     

    Measure_ = 
    VAR MinDateFromSelectedInterval = MIN('Calendar'[Date])
    VAR MinAvailableDateWithValues = CALCULATE(MIN('Values'[Date]), 'Values'[Date] >= MinDateFromSelectedInterval)
    RETURN
    CALCULATE(SUM('Values'[Value]), FILTER('Values', 'Values'[Date] = MinAvailableDateWithValues))

    Regards,

    ElenaN

ElenaN's avatar
ElenaN
Resolver V
7 years ago

Hello,

 

You can try this:

 

Measure_ = 
VAR MinDateFromSelectedInterval = MIN('Calendar'[Date])
VAR MinAvailableDateWithValues = CALCULATE(MIN('Values'[Date]), 'Values'[Date] >= MinDateFromSelectedInterval)
RETURN
CALCULATE(SUM('Values'[Value]), FILTER('Values', 'Values'[Date] = MinAvailableDateWithValues))

Regards,

ElenaN