Power Query formula writing using the SHIFT SHUFFLE

แชร์
ฝัง
  • เผยแพร่เมื่อ 2 ธ.ค. 2024

ความคิดเห็น • 27

  • @EricHartwigExcelConsulting
    @EricHartwigExcelConsulting ปีที่แล้ว +3

    Thank you for this great tip!
    I did not know about the Shift Shuffle method and I and going to put that one into use!
    A fun shortcut I learned in a meetup was to use the capital letters of the formula to create the formula quickly.
    Example DateTime.LocalNow would be typed in as DTLN and tab to populate the formula.

  • @ziggle314
    @ziggle314 ปีที่แล้ว

    I will use shift shuffle multiple times every day going forward. Thanks Wyn!

  • @josh_excel
    @josh_excel ปีที่แล้ว +1

    Good tip.
    Starting with the dot and typing the second half works fine

    • @AccessAnalytic
      @AccessAnalytic  ปีที่แล้ว +1

      Yep seen Chandeep do that one. Does rely on you remembering 2nd half

    • @josh_excel
      @josh_excel ปีที่แล้ว +2

      @@AccessAnalytic Correct :)

  • @OdelLeal
    @OdelLeal ปีที่แล้ว +1

    Woow that’s great tip “shift” key tricks. 🎉

  • @williamarthur4801
    @williamarthur4801 ปีที่แล้ว +1

    That was a great tip, I once mentioned the closing bracket thing on a site that dealt with a lot of pq,
    and was told it didn't matter if you type everything in in a linear fashion, so no wrapping,
    yeah like that's realistic.

  • @MyOnlineTrainingHub-p6b
    @MyOnlineTrainingHub-p6b ปีที่แล้ว +1

    Nice tip, Wyn!

  • @GrainneDuggan_Excel
    @GrainneDuggan_Excel ปีที่แล้ว +3

    Wyn, thanks for doing a short version of this tip! I have it saved in my 'keep this tip' file for when the brain freeze happens 🙄

  • @sue_bayes
    @sue_bayes ปีที่แล้ว +1

    Woop woop, thankyou Wyn

  • @inbartelem2084
    @inbartelem2084 ปีที่แล้ว

    You just solved this annoying problem for me - thanks a million.

  • @baskis69
    @baskis69 ปีที่แล้ว +1

    The dot is the devil....😈 ¡¡ Thaks for sharing¡¡

  • @GeertDelmulle
    @GeertDelmulle ปีที่แล้ว +1

    Well I have a PQ way of writing code and I always do type a dot. And it works just fine.
    There are several ways of doing this. :-)

    • @AccessAnalytic
      @AccessAnalytic  ปีที่แล้ว +1

      Yep, I’ve seen Chandeep saying he uses the dot.

  • @anilyadav-rt4sr
    @anilyadav-rt4sr ปีที่แล้ว

    Nice trick 👍

  • @joselencinamalgor6548
    @joselencinamalgor6548 ปีที่แล้ว

    Useful. I'll take a note to remember! Shift+👇 Shift+F9 😎