Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@rachaelwalker I screwed up, get rid of the first ) in your IF statement and should be good to go.
@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!
@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])
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)
@Greg_Deckler Not sure if I am plugging the correct tables in per your response. I am getting a syntax error.