Forum Discussion
Solved
Unificar formulas de lenguaje M
Hola, Espero que me puedan ayudar, tengo los siguiente campos a los que me aplique una serie de transformaciones Para obtener como resultado lo siguiente: Estos son los pasos apl...
Hi Carlos_Duran03 ,
You can generally remove all of your 'Changed Types' steps and apply the data types during calculation.
For example, line 13 could just become:
~ each Time.From([#"TRAMO - Copia"]) + #duration(0,0,30,0)and your line 15 could just be:
~ each Text.From([TRAMO]) & "-" & Text.From([Personalizado])Some examples of the functions you can use for this:
Date.From() DateTime.From() Time.From() Text.From()You can then just do a single 'Changed Types' step right at the end of your query before you send to the Data Model.
Pete
BA_Pete
Super User
Super UserHi Carlos_Duran03 ,
You can generally remove all of your 'Changed Types' steps and apply the data types during calculation.
For example, line 13 could just become:
~ each Time.From([#"TRAMO - Copia"]) + #duration(0,0,30,0)and your line 15 could just be:
~ each Text.From([TRAMO]) & "-" & Text.From([Personalizado])
Some examples of the functions you can use for this:
Date.From()
DateTime.From()
Time.From()
Text.From()
You can then just do a single 'Changed Types' step right at the end of your query before you send to the Data Model.
Pete