Latest Record by Multiple First Dates

[pbi_besi]

Hi Community, 

I want to show the next scheduledend date (date) in one column and the due type (phone call, task, etc.) in another column.

Problem:

If I now have two different due types on the same scheduledend date, it shows me both.

Goal:

No matter which of the two due types is displayed, I would like to have only 1 due type displayed (not both).

My DAX currently (that does not work:

Next Activity Typecode = 
VAR _NextActivityDate =  
    MIN('Aktivitäten'[scheduledend])
return
    CALCULATE(
            MIN('Aktivitäten'[activitytypecode_name_open]),
            FILTER('Aktivitäten','Aktivitäten'[scheduledend]=_NextActivityDate)
    )

Can someone help me achieve the goal?

[pbi_besi]

@BeaBF  Thank you for your help. 

Unfortunately, the column now shows me no values at all. Do you know what this could be?

The remaining columns are from another table...

[BeaBF · Accepted solution]

@pbi_besi try:

Next Activity Typecode = VAR _NextActivityDate =
MIN('Aktivitäten'[scheduledend]) RETURN FIRSTNONBLANK( DISTINCT( FILTER('Aktivitäten', 'Aktivitäten'[scheduledend] = _NextActivityDate), 'Aktivitäten'[activitytypecode_name_open] ), 1 )

BBF

[pbi_besi]

@BeaBF Thank you both!
@FreemanZ FYI

[FreemanZ]

hi @pbi_besi 

the screenshot, is it table visual or data table?

[pbi_besi]

hi @Freeman 

it is a table visual

[FreemanZ]

can you make screenshot with a full overview of the table visual?