Power Query - Sorting is Sometimes Pointless (VertiPaq Insights)

Поділитися
Вставка
  • Опубліковано 10 гру 2024

КОМЕНТАРІ • 25

  • @Quidisi
    @Quidisi 16 днів тому +2

    This was helpful.
    True story - I'm so dumb, that until recently,I used to spend time in PQ sorting AND arranging columns. Did a lot of things that broke query folding and caused slowdowns. Then one day I asked myself, why am I trying to get my data all neat in PQ? Who cares... take care of it in the visuals.
    But as you said, sometimes sorting is necessary to further transform your data - but apart from that, I stopped sorting and I stopped arranging columns.

    • @bcti-bcti
      @bcti-bcti  16 днів тому

      @@Quidisi Glad you found this helpful and that the lessons are valid. Save that time for other things, like visuals refinement. Thanks for watching.

  • @ahmedshalaby9343
    @ahmedshalaby9343 16 днів тому

    Greetings from Egypt , since the first time I saw I video for you I decided to watch whatever are your posting on YT because you are smart

    • @bcti-bcti
      @bcti-bcti  16 днів тому

      Thank you (from the U.S. of A.). That is an incredibly nice thing for you to say. I'll try not to let you down in future videos. Thanks for watching and your support. Cheers.

  • @JuanCVazquez-s9k
    @JuanCVazquez-s9k 16 днів тому +1

    Awesome! Very interesting and helpful. Thanks Professor.

    • @bcti-bcti
      @bcti-bcti  16 днів тому

      @@JuanCVazquez-s9k Glad you found it useful. Thanks for your comment.

  • @kebincui
    @kebincui 16 днів тому

    Great video which clear the unclear issue of sorting and removing duplicate row to get the latest record. 👍👍

    • @bcti-bcti
      @bcti-bcti  16 днів тому

      Thank you! I thought I was going mad for a while when witnessing this behavior. Cheers.

  • @Swizzletwice
    @Swizzletwice 16 днів тому

    Interesting video and explanation of data compression techniques.

    • @bcti-bcti
      @bcti-bcti  16 днів тому

      Thank you. I appreciate your viewership and support.

  • @iankr
    @iankr 13 днів тому

    Fascinating! Many thanks. 😊

    • @bcti-bcti
      @bcti-bcti  13 днів тому

      @@iankr Glad you like it. Thanks to you, too.

  • @RonDavidowicz
    @RonDavidowicz 16 днів тому

    Excellent explanation

    • @bcti-bcti
      @bcti-bcti  16 днів тому

      Thanks again!!! Glad you found this helpful.

  • @chrism9037
    @chrism9037 17 днів тому

    Interesting, thanks! I never really noticed this

    • @bcti-bcti
      @bcti-bcti  17 днів тому

      @@chrism9037 Things that make you go “hmmm”. Thanks for watching and commenting.

  • @kkravch
    @kkravch 17 днів тому +1

    Thanks, very helpful, professor. It seems to be the reason why we need Table.Buffer when Group by depends on sort order...

    • @bcti-bcti
      @bcti-bcti  17 днів тому

      @@kkravch Yes, that could very well be. Thanks for watching.

  • @williamarthur4801
    @williamarthur4801 17 днів тому +2

    'Now you understand' yeah right, this is going to take just a few more re runs.

    • @bcti-bcti
      @bcti-bcti  17 днів тому +1

      @@williamarthur4801 Watch it 100 more times. It helps my view count. 🤣

  • @16-7
    @16-7 16 днів тому

    Thanks for the video. I was mystified why, when combining CSV files, where the primary column is consecutive days, or date and time at set intervals, the rows become jumbled up when loaded into Excel.

    • @bcti-bcti
      @bcti-bcti  16 днів тому

      Exactly! I was puzzled for the longest time over this behavior. Thanks for watching.

  • @jasongins
    @jasongins 16 днів тому

    I've seen this with the data model, but never knew the nuts and bolts as to why. I won't get mad at it anymore. How did you figure out that it is a memory management strategy by way of the various encodings?

    • @bcti-bcti
      @bcti-bcti  16 днів тому +4

      @@jasongins By reading a VERY long and in-depth book named “The Definitive Guide to DAX” by Marco Russo and Alberto Ferrari. Thanks for watching.