Power Query - Remove rows with null values

Поділитися
Вставка
  • Опубліковано 18 лип 2023
  • #shorts How to remove rows in a datasets that contain nulls across all columns.
    #dataanalytics #powerbi #powerquery

КОМЕНТАРІ • 6

  • @guy4432
    @guy4432 7 місяців тому +2

    I spent hours googling trying to remove null values. Watched countless UA-cam videos. Then this 30 second reel solved my issue. Thank you

  • @garywilhelm2299
    @garywilhelm2299 11 місяців тому +4

    This works but I don't know why you wouldn't just use the User Interface: Remove Rows, Remove Blank Rows

    • @basensei8699
      @basensei8699  11 місяців тому +5

      ye sure! the ui is perfect for this common use case. And i'd use the UI also. But the point when i create videos like these are to get people to understand the mechanics of the underlying mquery language so one can solve other more complicated problems. And that only ocmes from understanding how the language works :)

    • @garywilhelm2299
      @garywilhelm2299 11 місяців тому +4

      @@basensei8699 That makes a lot of sense. Your videos are very instructive. keep it up

  • @sudbn
    @sudbn 5 місяців тому

    we can filter null easily

  • @albiejade1985
    @albiejade1985 2 місяці тому

    I'm getting errors