Forum Discussion

antlufc's avatar
antlufc
Frequent Visitor
3 years ago

Value Based on Max Date from Another Column

Hi,  I am looking to find a DAX measure/measures that will let me find the value of a sales lead based upon the max date time only if there is more than one entry in the same month. I do not want ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi antlufc 
Please refer to attached sample file with the proposed solution

Measure = 
SUMX ( 
    SUMMARIZE ( 'Table', 'Table'[pipeline_journey_id], 'Table'[event_date] ),
    MAXX ( 
        INTERSECT ( 
            'Table',
            TOPN ( 
                1,
                CALCULATETABLE ( 
                    'Table', 
                    ALLEXCEPT ( 'Table', 'Table'[pipeline_journey_id],'Table'[event_date] ) 
                ),
                'Table'[event_datetime]
            )
        ),
        'Table'[amount_average_contract_value]
    )
)