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 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?

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

6 Replies

  • 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
      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