Forum Discussion
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 aplicados
Este es el editor avanzado:
Habra alguna manera de que se pueda unificar la linea 9 y 10 o 12 y 13 o que lineas se podria unificar para tener una sola formula, o quisas no se puedan unir, espero que me pueda ayudar con esto.
Adicional donde podria tomar un curso en español de preferencia o en ingles pero son subtitulos en españos de lenguaje M y DAX
Saludos.
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
4 Replies
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
No problem, glad it's helped.
Don't forget to give a thumbs-up to any posts that help you 👍
Pete
