Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
PowerBI123456
Post Partisan
Post Partisan

Adición de ceros iniciales en Power Query

‎12-15-2020 02:46 PM

¿Cómo puedo agregar ceros a la izquierda en Power Query solo si se cumplen determinados criterios? Por ejemplo, tengo una columna donde el número de dígitos puede variar de 10-13, pero todos ellos necesitan ser 13 dígitos. Así que si el campo contiene 10 dígitos, tendría que agregar 3 ceros a la izquierda. Si contenía 11 dígitos, tendría que añadir 2 ceros a la izquierda, etc.

¡Gracias!

Message 1 of 6
13,666 Views
0
1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion
In response to PowerBI123456

‎12-15-2020 08:10 PM

@PowerBI123456 , a continuación, se hace referencia a una columna específica en la fórmula

Table.AddColumn(#"Previous step", "Leading 0s", each Number.ToText([number column], Text.Repeat("0",13)))

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

Message 4 of 6
13,625 Views
5 REPLIES 5
mahoneypat
Employee
Employee

‎12-15-2020 03:37 PM

Si necesita mantenerlos como formato numérico, también puede usar Cadenas de formato personalizado después de cargar los datos.

Usar cadenas de formato personalizado en Power BI Desktop - Power BI Documentos de Microsoft

saludos

palmadita





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Message 6 of 6
13,656 Views
0
CNENFRNL
Community Champion
Community Champion

‎12-15-2020 03:26 PM

Hola, @PowerBI123456, es posible que desee seguir este patrón para dar formato a todos los números,

Number.ToText(1234567890, Text.Repeat("0",13))

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Message 2 of 6
13,661 Views
0
PowerBI123456
Post Partisan
Post Partisan
In response to CNENFRNL

‎12-15-2020 03:32 PM

@CNENFRNL Gracias, ¿qué pasa si quiero hacer referencia a una columna específica?

Message 3 of 6
13,660 Views
0
CNENFRNL
Community Champion
Community Champion
In response to PowerBI123456

‎12-15-2020 08:10 PM

@PowerBI123456 , a continuación, se hace referencia a una columna específica en la fórmula

Table.AddColumn(#"Previous step", "Leading 0s", each Number.ToText([number column], Text.Repeat("0",13)))

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Message 4 of 6
13,626 Views
PowerBI123456
Post Partisan
Post Partisan
In response to CNENFRNL

‎12-16-2020 10:12 AM

@CNENFRNL gracias!

Message 5 of 6
13,618 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

View All