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 everyone!
Trying to get my head around this and not getting very far!
I have 2 tables - Problem, and Task. The two are related via Problem ID. Each Problem will have multiple tasks.
Problem contains:
Problem ID
Problem Last Modified Date
Task Contains
Problem ID
Task ID
Task Last Modified Date
Each row in Problem is unique, ie one Problem per row.
Tasks will have around 4 rows per problem, each with a potentially different last modified date.
What I want to achieve is:
Compare the Problem Last Modified date with the Maximum Task Last Modified date. Whichever is greater gets populated into the custom column within the Problem Table. Possibly explained this really badly, but hopefully this pic will help illustrate what I mean:
Solved! Go to Solution.
@silverdale9999 - Should be:
Column =
VAR __Other = MAXX(RELATEDTABLE('Table2'),[Task Last Modified Date])
RETURN
MAXX( {[Last Modified Date], __Other },[Value])
Hi,
There might be a better way to do this but at the top of my head this works.
Update_Date =
VAR _new = CALCULATE(MAX('TaskTable'[TaskUpdateDate]),RELATEDTABLE(ProblemTable))
Return
You can add isblank() if you need.
@silverdale9999 - Should be:
Column =
VAR __Other = MAXX(RELATEDTABLE('Table2'),[Task Last Modified Date])
RETURN
MAXX( {[Last Modified Date], __Other },[Value])
That works perfectly ! Thanks so much for taking the time to reply.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |