Forum Discussion

pbi_besi's avatar
pbi_besi
New Member
3 years ago
Solved

Latest Record by Multiple First Dates

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 t...
DAX
  • BeaBF's avatar
    BeaBF
    3 years ago

    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's avatar
pbi_besi
New Member
3 years ago

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's avatar
BeaBF
Icon for Super User rankSuper User
3 years ago

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