Understanding apply semantics for window functions in DAX

Поделиться
HTML-код
  • Опубликовано: 20 май 2024
  • Apply semantics is a new way of computing table expressions when multiple rows are selected in DAX window functions.
    Article and download: sql.bi/836012?aff=yt
    How to learn DAX: www.sqlbi.com/guides/dax/?aff=yt
    The definitive guide to DAX: www.sqlbi.com/books/the-defin...
  • НаукаНаука

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

  • @VictorHugo-bd3bf
    @VictorHugo-bd3bf Месяц назад +2

    I had to watch it two times to understand. Thanks so much, Alberto. As usual, the content is amazing.

  • @AhmedCherif-mt5lb
    @AhmedCherif-mt5lb Месяц назад +1

    You are wonderful Mr Alberto, greetings from Tunisia🤩

  • @nazimscr
    @nazimscr Месяц назад +2

    Congratulations on 100k subscribers, 🎉🎉🎉

  • @wilsonman8661
    @wilsonman8661 Месяц назад +1

    "I don't expect people to use this as a feature because it's actually uselessly complicated."
    This is my main takeaway! Thanks for another video. :D

  • @nonoobott8602
    @nonoobott8602 Месяц назад +1

    Very insightful video as usual. Thanks for sharing

  • @gurvindersingharora5301
    @gurvindersingharora5301 Месяц назад

    Hello Sir,
    When to combine ALL function with Calculate + Filter function in DAX ?
    Please make a video of it 🙏 ❤

  • @davidoj519
    @davidoj519 Месяц назад +1

    Wow, i repeated the video 4 or 5 times to understand and i have questions yet xD

  • @sarajvo2010
    @sarajvo2010 Месяц назад

    Is appy semantic available only in DAX, relaing to windows functions?

    • @SQLBI
      @SQLBI  Месяц назад +1

      Yes!

  • @tareksalha
    @tareksalha Месяц назад +1

    I never understood, why people started with window functions in dax…
    You can also achieve the same results with ordinary functions that do not preserve order (presumably due to clean data modeling 😉)