Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
Jomati
Regular Visitor

undefine

Consulta

Hola mi nombre es joaquin, me encuentro realizando un cruce de informacion desde distintas planillas Excel, Con el objetivo de cruzar información en graficas.

 

Para ello logre identificar desde la planilla de fechas de instalacion los componentes y su ultima fecha de instalación, pero luego de ir aplicando las distintos pasos. Es que llego a paso de combinar columnas entre planillas y hasta ese momento todo bien con la ultima fecha de instalación, es decir, se mantiene en la ultima requerida.

 

 

Jomati_0-1722567020202.png

 

Luego se aplicar un paso de expandir ID de componente, se cambia a la primera fecha de instalación. 

Jomati_1-1722567020205.png

 

 

Agradeceria bastante si alguien me puede aclarar por que sucece y que deberia realizar para que me quede la ultima fecha de instalación del componente.

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @Jomati ,

 

Thanks for reaching out to the community.

However, I can't make out your first image, and since you merged four images into one, I'm going to be blurry.

As you said, it goes well until you do the last step. However, if there is a problem after expanding, then the cause of the problem should appear in this step, please check carefully.

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

lbendlin
Super User
Super User

Consider investing in a proper data model to create these relationships without the need to combine your tables.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors