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

BeaBF's avatar
BeaBF
Super 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