Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help with power query code

hello to tod@s, I need your help, I am currently connected to a server importing the data. What happens is that the server does not overpend the data when it is updated so it is duplicated; triple, etc. the data.

I have the update dates, however I have no knowledge of a code that allows me to take the last update date, currently only updates me with the update date of October 4:

Let
Source - Sql.Databases("amsazsdw01.database.windows.net"),
amsazsdw01 - Origin-[Name-"amsazsdw01"]-[Data],
amsa_staged_sap_ehs_ZEHS_REP14 . . . . . . . . . . . . . . . . . . . . . . . . . ZEHS_REP14 amsa_staged_sap_ehs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
"Filtered Rows" - Table.SelectRows(amsa_staged_sap_ehs_ZEHS_REP14, each ([COMPANY] ? "Minera Los Pelambres / ID: 187")),
"Removed Columns" - Table.RemoveColumns(-"Filtered Rows","MANDT", "RUT_EMP", "QUESTION1", "QUESTION2", "QUESTION3"-),
"Filtered Rows1" - Table.SelectRows(-"Removed Columns", each ([fecextr2] - #date(2020, 10, 4)))
in
"Filtered Rows1"

  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    Hi, Anonymous 

     

    Based on my tests, there is no option to get the lastest updated datetime. Here is my codes in 'Advanced Editor'.

    let
    Source = Sql.Databases("ServerName"),
    test = Source{[Name="DataBaseName"]}[Data]
in
    test

     

     

    You may try using corresponding names to name the table and then filter the latest one with 'Table.SelectRows'.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-alq-msft's avatar
    v-alq-msft
    Community Support
    5 years ago

    Hi, Anonymous 

     

    Based on my tests, there is no option to get the lastest updated datetime. Here is my codes in 'Advanced Editor'.

    let
    Source = Sql.Databases("ServerName"),
    test = Source{[Name="DataBaseName"]}[Data]
in
    test

     

     

    You may try using corresponding names to name the table and then filter the latest one with 'Table.SelectRows'.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.