Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with LOOKUPVALUE

Hello everyone,   I have two tables: TAB_Summary and TAB_Projects.   TAB_Summary Project # Stage Days in Stage 1 Idea 10 2 Development 15 3 Launch 20   TAB_Projects ...
Need Help
Show and Tell
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , a new column in the summary table

Days in Stage = sumx(filter(TAB_Projects,TAB_Projects[Project #] = TAB_Summary[Project #] && TAB_Projects[Stage] =TAB_Summary[Stage] ),TAB_Projects[Days in Stage])