Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
try like
Oldest =
MAXX(
RELATEDTABLE(FACT_Task),
FACT_Task[Close Date]
)
try like
Oldest =
MAXX(
RELATEDTABLE(FACT_Task),
FACT_Task[Close Date]
)
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
87 | |
74 | |
66 |
User | Count |
---|---|
124 | |
112 | |
96 | |
80 | |
72 |