Forum Discussion

MRUGLADIATOR's avatar
MRUGLADIATOR
New Member
2 years ago
Solved

DAX HELP - Return Corresponding value for minimum date

Hi there!   I am somewhat new to DAX and I am running into an issue:   I am using the "Opportunities Table" from the Regional Sales Sample pbix file and I am trying to do the following:   ...
Need Help
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi MRUGLADIATOR,

    Please try this DAX formula:

     

    SUM Value EarliestDate = 
VAR _EarliestDate = [Earliest Created Date]
VAR _Table = 
FILTER(
    Opportunities,
    [Opportunity Created On] = _EarliestDate
)
VAR _Result = 
    SUMX(
        _Table,
        Opportunities[Value]
        )
RETURN
    _Result

     

    The final output should be this:

     


    I'm attaching the pbix file with my solution.

     

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Hi MRUGLADIATOR,

Please try this DAX formula:

 

SUM Value EarliestDate = 
VAR _EarliestDate = [Earliest Created Date]
VAR _Table = 
FILTER(
    Opportunities,
    [Opportunity Created On] = _EarliestDate
)
VAR _Result = 
    SUMX(
        _Table,
        Opportunities[Value]
        )
RETURN
    _Result

 

The final output should be this:

 


I'm attaching the pbix file with my solution.