Forum Discussion

fmerieux's avatar
fmerieux
Frequent Visitor
3 years ago
Solved

Slow performance with custom function applied to table

Hello everyone,   I have 3 different queries that contains list of articles and each query has a column that I want to apply to the other queries in order to have a comprehensive view of all the ar...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi fmerieux ,
    have you considered full outer join options for the merges?: Full outer join - Power Query | Microsoft Learn
    Otherwise, please post file with some mock-up data.
    I currently specifically don't understand the effect of the filters you are applying here:

        #"Keepit" = Table.SelectRows(#"FillDown",

             each [Level]<>0 or [#"Descript. synth."]<> null or [Index] = {Table.RowCount(TableDataConso)}[Index] )
    So very difficult to come up with alternative solutions here.

     

ImkeF's avatar
ImkeF
Community Champion
3 years ago

Hi fmerieux ,
have you considered full outer join options for the merges?: Full outer join - Power Query | Microsoft Learn
Otherwise, please post file with some mock-up data.
I currently specifically don't understand the effect of the filters you are applying here:

    #"Keepit" = Table.SelectRows(#"FillDown",

         each [Level]<>0 or [#"Descript. synth."]<> null or [Index] = {Table.RowCount(TableDataConso)}[Index] )
So very difficult to come up with alternative solutions here.