Power Query - Unstack Rows with List.Alternate

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

КОМЕНТАРІ • 23

  • @johnnystv4067
    @johnnystv4067 3 місяці тому +1

    How useful, thank you for sharing!

  • @MichaelBrown-lw9kz
    @MichaelBrown-lw9kz 8 місяців тому +2

    Impressive stuff.
    I have to accept that it will take me years of practice to master Power Query and DAX.

  • @corradoagnoletto905
    @corradoagnoletto905 7 місяців тому +1

    Interesting! But to get an array from a list the fast way is to use the index function with sequence.

  • @apellawitong
    @apellawitong Місяць тому

    You are a genius.

    • @basensei8699
      @basensei8699  Місяць тому

      hahah totally not a genius but thank you!

  • @13kriztian
    @13kriztian Місяць тому

    Cool DAX trick

  • @yousrymaarouf2931
    @yousrymaarouf2931 7 місяців тому

    Fantastic

  • @aman_mashetty5185
    @aman_mashetty5185 8 місяців тому

    Awesome..! Never knew about list.alternate

  • @aart_analyst
    @aart_analyst 8 місяців тому

    Good stuff, James. Always learning new things with you.

  • @rajanpradeepankarath8846
    @rajanpradeepankarath8846 4 місяці тому

    brilliant!

  • @tonybatty504
    @tonybatty504 8 місяців тому

    Great series of videos and learnt a lot of PQ functions!

  • @fortunatodirado3176
    @fortunatodirado3176 7 місяців тому

    Thanks!!!

  • @IvanCortinas_ES
    @IvanCortinas_ES 7 місяців тому

    Complex function. Thank you.

  • @kebincui
    @kebincui 8 місяців тому

    Awesome as always 👍

  • @mnowako
    @mnowako 7 місяців тому

    Amazing! Thanks a lot!

  • @gabriusv
    @gabriusv 7 місяців тому

    Hey James, it sounds like your microphone audio is mixed only through the left channel. Your audio effects are correctly playing through both the left & right channels. As a quick band-aid, you could try turning your microphone audio from dual channel to mono!
    I do see that you're using a dedicated microphone, so it's possible your not recording from the correct source. Hard to diagnose without knowing your set-up.
    Let's chat some time! I also come from a video editing background & I know enough about audio to be dangerous.

  • @ExcelWithChris
    @ExcelWithChris 8 місяців тому

    Dankie!!!

  • @VintageReplay-pt5xk
    @VintageReplay-pt5xk 7 місяців тому

    Just hijacking your video here, I have tried reaching out to you on your contact form the on website but this isnt working for some reason! You have a goldmine of info on this chanel and I was trying to get in contact to see if you could do some ad-hoc consultancy for me as I am having a mare of a job trying to get a couple of queries going!

    • @basensei8699
      @basensei8699  7 місяців тому

      Glorious ! Thank you indeed! And Sure thing contact me on jamesbotes@basensei.com :)

  • @lcorcoran56
    @lcorcoran56 8 місяців тому +1

    Love the video's, I learn a lot, but I keep thinking there is something wrong with earbubs, I only hear him out of the left ear bud if he plays
    Any other sounds it is fine, so it get annoying with the bad audio sorry if I sound like at troll

    • @MrJamesbotes
      @MrJamesbotes 8 місяців тому

      Damn I didn't know that ! I think it might be my mic ! Thank you for letting me know !

    • @basensei8699
      @basensei8699  8 місяців тому +1

      thanks for letting me know man i really didnt even know about this until now!