Power Query (Excel) + M Code | GroupBy - Table.Group & Table.FuzzyGroup

Поделиться
HTML-код
  • Опубликовано: 16 янв 2025

Комментарии • 14

  • @alexrosen8762
    @alexrosen8762 Год назад +1

    Very useful. Thanks 🙏

  • @StefanoVerugi
    @StefanoVerugi 2 года назад +1

    good stuff, thanks

  • @Sumanth1601
    @Sumanth1601 2 года назад +1

    Wow that fuzzy logic one was something new :) Awesome trick

    • @bsmart2gether408
      @bsmart2gether408  2 года назад

      👍 Thank you Sumanth

    • @Sumanth1601
      @Sumanth1601 2 года назад

      @@bsmart2gether408 if you are making another video on this topic, please show some example of groupkind.local .. looks to be quite useful:)

    • @bsmart2gether408
      @bsmart2gether408  2 года назад +1

      @@Sumanth1601 I am not a fan at using groupkind .local even though it speeds up query a bit but we need to get the sequence right in some cases. I have noted down and think through what's best to apply groupkind.local.

  • @DK_85
    @DK_85 2 года назад +2

    Thanks a lot! Again very helpful and well explained. I think it would be great to listen to your original voice soon ;)

    • @bsmart2gether408
      @bsmart2gether408  2 года назад +1

      Thank you Dennis. I have attempted to do voice over. A few technical challenges at this stage but I will definitely use my voice once all technical challenges are off the way.

  • @smartwork4768
    @smartwork4768 2 года назад

    Awesome. Got the new idea

  • @mirrrvelll5164
    @mirrrvelll5164 2 года назад

    Very informative as usual - spammer me! =) I am already subscribed with a bell =) just something to note, try to do some videos on topics like:
    - dynamic path (from file and from folder) when someone else is using same Excel file and wants to update
    - or even modern, from sharepoint refresh files
    - writing like "Date/calendar" table - query
    - I have xillions of topics, and you know that also, it is simply super huge...
    If I come across with some issue I will ask for an assistance.
    Thanks and keep doing videos!

    • @bsmart2gether408
      @bsmart2gether408  2 года назад

      Hi mirr velll, I have covered some dynamic file path in the earlier videos. Happy to cover more as I constantly change my way of doing things. Feel free to throw in things you want to know and I am always happy to add on to my list. :)
      Happy for you or anyone to tag @KT_Bsmart2gethe in Power BI Community (community.powerbi.com/t5/Power-Query/bd-p/power-bi-services) when you need assistance or guidance. It will be much quicker than me create video for something you want to know quick :)