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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.