Hopefully you folks can help out with this as I am stuck.
I have two tables that are linked by a Run_ID
The activity table shows the status changes of runs and I want to know the difference between what is actually happening and what was planned.
I want to know the difference in time between JobRun[RunPickupTime] and Activity[ActivityTime] where Activity[RunStatus]=4
As there may be duplicate rows where the Activity[RunStatus] is the same I need to also limit it to show the time with the lowest Activity[ActivityID]
Cheers in advance.
Go to Solution.
Try this calculated column out (in JobRun):
VAR tmpTable = FILTER(RELATEDTABLE(Activity),[RunStatus]=4)
VAR minActivityID = MINX(tmpTable,[ActivityID])
VAR tmpTable1 = FILTER(tmpTable,[ActivityID]=minActivityID)
Proud to be a Super User!
View solution in original post
This worked great! Thanks so much @Greg_Deckler for the solution. First time I have used VAR as well. Learning time.
Check out a full recap of the month!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.