Word Frequency counter Power Query

Sdílet
Vložit
  • čas přidán 3. 12. 2017
  • In today's video I will show you how to count words in Power Query.
    I will be following Chris Webbs awesome tutorial:
    blog.crossjoin.co.uk/2013/03/...
    Looking for a download file? Go to our Download Center: curbal.com/donwload-center
    SUBSCRIBE to learn more about Power and Excel BI!
    / @curbalen
    Our PLAYLISTS:
    - Join our DAX Fridays! Series: goo.gl/FtUWUX
    - Power BI dashboards for beginners: goo.gl/9YzyDP
    - Power BI Tips & Tricks: goo.gl/H6kUbP
    - Power Bi and Google Analytics: goo.gl/ZNsY8l
    ABOUT CURBAL:
    Website: www.curbal.com
    Contact us: www.curbal.com/contact
    QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
    ► Twitter: @curbalen, @ruthpozuelo
    ► Google +: goo.gl/rvIBDP
    ► Facebook: goo.gl/bME2sB
    #SUBSCRIBE #CURBAL
    ► Linkedin: goo.gl/3VW6Ky

Komentáře • 21

  • @NorbertoVeraReatigaNVR
    @NorbertoVeraReatigaNVR Před 6 lety +2

    Muy buen truco para análisis de texto con Power Query, Muchas gracias Ruth!!

    • @CurbalEN
      @CurbalEN  Před 6 lety

      +Norberto Vera Reatiga Hola Norberto!
      Si, y fíjate es del 2013!
      /Ruth

  • @rolandotemporale791
    @rolandotemporale791 Před 6 lety +1

    as always, sharing interesting stuffs, Thanks Ruth

    • @CurbalEN
      @CurbalEN  Před 6 lety

      +Rolando Temporale Thanks to you for watching ;)
      /Ruth

  • @juansepowerplatform
    @juansepowerplatform Před 6 lety +2

    Good video on how to get familiar with the advanced editor syntax. Thank you

    • @CurbalEN
      @CurbalEN  Před 6 lety

      +Juan Grijalba True! Multipurpose vídeo then :)
      /Ruth

  • @rachel7920
    @rachel7920 Před 4 lety

    Thank you!!

  • @safiyadevarshi839
    @safiyadevarshi839 Před rokem

    Great video. This helped me a lot..❤

  • @DawnPeacockOwens
    @DawnPeacockOwens Před 2 lety

    thank you! Very helpful!

  • @kallbrand
    @kallbrand Před 4 lety

    Trevlig video. Jag hade nytta av den när jag ville komplettera ett Word Cloud-diagram.

  • @Sal_A
    @Sal_A Před 6 lety +1

    Never done any text analysis but it looks cool. It would be helpful if you could explain the arguments for each part of the PQ function you are using. In addition, explain functions like Splitter.SplitTextByWhiteSpace and why you put it inside the { }. Also, why in some cases you use the # sign and not in others.

    • @CurbalEN
      @CurbalEN  Před 6 lety

      +Sal A Great idea, that will give a greater understanding of power query.
      /Ruth

  • @rrrraaaacccc80
    @rrrraaaacccc80 Před 11 měsíci

    👍💯

  • @nav1877
    @nav1877 Před rokem

    Hello I followed your steps up until split words was waiting on list but get the following error Expression.Error: We cannot convert the value "nav is a 15-year-..." to type Number.

  • @vida1719
    @vida1719 Před 6 lety +1

    It's a good idea to learn from mistakes.

    • @CurbalEN
      @CurbalEN  Před 6 lety

      +Vida Yes, it is my way of learning as you can see in the video ;)
      /Ruth

  • @cecewang70
    @cecewang70 Před rokem

    u confused me