Unificar formulas de lenguaje M

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