Forum Discussion

IvanS's avatar
IvanS
Helper V
3 years ago
Solved

Find oldest task for each user

Hi,


I have 2 tables - DIM_Users and FACT_Tasks with fields as per below:

 

DIM_Users:

- User name

 

FACT_Tasks

- Task ID

- Close Date

 

I am trying to identify the oldest (resp. the first) closed task from FACT_Tasks table for each user in table DIM_Users. Could you please help me? The result should be new column in table DIM_Users. If there is no closed task for user yet, the field should be empty.

 

Thank you

IvanS

  • try like

    Oldest =

    MAXX(

       RELATEDTABLE(FACT_Task),

       FACT_Task[Close Date]

    )

2 Replies

  • try like

    Oldest =

    MAXX(

       RELATEDTABLE(FACT_Task),

       FACT_Task[Close Date]

    )

    • IvanS's avatar
      IvanS
      Helper V

      Thank you - but as I want oldest (resp. first task) I need to use MINX function. Please correct your reply so it is not confusing other users 🙂