Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
Proud to be a Datanaut!
No problem, glad it's helped.
Don't forget to give a thumbs-up to any posts that help you 👍
Pete
Proud to be a Datanaut!
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
Proud to be a Datanaut!