Forum Discussion
Conditional Lookup on a related table
I wanting to pull data from one column into a new one based on information from another column in another table. Here is an example of my tables. I want a new Utilized Hours column to populate "Actual Hours" if it is flagged utilized. Same concept for Non-Utilized
rachaelwalker I screwed up, get rid of the first ) in your IF statement and should be good to go.
5 Replies
rachaelwalker If I understand this correctly, you could add columns like the following:
Utilized Hours Column = VAR __WorkTypeID = [WorkTypeID] VAR __UtilizationFlag = MAXX(FILTER('WorkType',[WorkTypeID]=__WorkTypeID),[UtilizationFlag]) RETURN IF(__UtilizationFlag),[ActualHours],0) Non-Utilized Hours Column = VAR __WorkTypeID = [WorkTypeID] VAR __UtilizationFlag = MAXX(FILTER('WorkType',[WorkTypeID]=__WorkTypeID),[UtilizationFlag]) RETURN IF(__UtilizationFlag),0,[ActualHours])Greg_Deckler Not sure if I am plugging the correct tables in per your response. I am getting a syntax error.
I was thinking I could do LOOKUPVALUE and pull UtilizationFlag (true or false) into the TimeEntries table. Then did an If statement but the numbers are not reflecting accurately.
Lookup formula Utilization = LOOKUPVALUE(WorkTypes[WorkTypes.utilizationFlag], WorkTypes[WorkTypes.id], TimeEntries[TimeEntries.workType.id]) If statement Utilized Hours = IF('TimeEntries'[Utilization] = "True", TimeEntries[TimeEntries.actualHours], 0)
rachaelwalker I screwed up, get rid of the first ) in your IF statement and should be good to go.
That worked!! Thank you so much!
