cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gdps
Helper IV
Helper IV

Ayuda con LOOKUPVALUE

Hola a todos,

Tengo dos tablas: TAB_Summary y TAB_Projects.

TAB_Summary

Proyecto #EtapaDías en etapa
1Idea10
2Desarrollo15
3Lanzamiento20

TAB_Projects

Proyecto #EtapaDías en etapa
1Idea10
2Idea10
2Desarrollo15
3Idea10
3Desarrollo14
3Lanzamiento20

Me gustaría obtener el valor de Días en Etapa de TAB_Projects correspondiente a la etapa en la que se encuentra el proyecto en TAB_Summary.

Para ello, pensé en crear una columna calculada usando LOOKUPVALUE

Days in Stage = LOOKUPVALUE(TAB_Projects[Days in Stage],TAB_Projects[Project #],TAB_Summary[Project #],TAB_Projects[Stage],TAB_Summary[Stage])

Pero estoy recibiendo el siguiente error: "Se proporcionó una tabla de varios valores donde se esperaba un solo valor"

¿Alguna idea de cómo resolver este problema?

Saludos

2 REPLIES 2
amitchandak
Super User
Super User

@Gdps , una nueva columna en la tabla de resumen

Días en la etapa á sumx(filter(TAB_Projects,TAB_Projects[Proyecto ?] - TAB_Summary [Proyecto ]&& TAB_Projects[Etapa] TAB_Summary [Etapa] ),TAB_Projects [Días en etapa])



New Power BI Features
Datamarts: https://youtu.be/8tskWsJTEpg
Field Parameters : https://youtu.be/lqF3Wa1FllE?t=70
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin !! Proud to be a Super User!
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
!! Subscribe to my youtube Channel !!
Greg_Deckler
Super User
Super User

@Gdps - Difícil de estar seguro. El error que recibe generalmente se encuentra al crear una medida. Puede probar el enfoque MAXX(FILTER,...):

Days in Stage = MAXX(FILTER(TAB_Projects, TAB_Projects[Project #] = TAB_Summary[Project #] && TAB_Projects[Stage] = TAB_Summary[Stage]),TAB_Projects[Days in Stage])


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.