Row context in DAX explained visually

Поделиться
HTML-код
  • Опубликовано: 8 сен 2024
  • A visual representation of the DAX row context helps to understand the related conceptual model.
    Article and download: sql.bi/843689?...
    How to learn DAX: www.sqlbi.com/...
    The definitive guide to DAX: www.sqlbi.com/...

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

  • @adilmajeed8439
    @adilmajeed8439 Месяц назад +5

    Love the way that has been explained, please continue the series. Once you see the things visually what we have read from your book, it makes a huge difference. Kodos to you and your steam for starting this visual series of explanations.

  • @SirHazey1
    @SirHazey1 Месяц назад +8

    This series is the best thing I've seen from SQLBI. Filter and Row context are the foundation of understanding DAX and doing it well, and definetly deserved this more granular, slower paced explanation.
    Well done all!

  • @gvitullib
    @gvitullib Месяц назад +9

    Good video. Going back to basics is always welcome. Thank you!

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

      You can find most of the external tools here: www.sqlbi.com/tools/

  • @sheilamarlene1
    @sheilamarlene1 2 дня назад

    Thank you! Some of us learn visually. ❤

  • @nhatthuonghuynh9604
    @nhatthuonghuynh9604 Месяц назад +3

    Great content. Now that we have filter and row context videos, please make the context transition visual explanation too 😄

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

      Of course!

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

    I'm marking this as one of my favorite videos.

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

    Being able to see (no better word) in the measures i create or assist is great, explaining it, not easy, this video and will be a good reference, really can't wait for context transition as thats just not possible with the words I know, jumping to filter now, i saw them in reverse

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

    Great video! Thank you very much!
    I finally understand it!!

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

    Great way of teaching. Thank you.

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

    Amazing explanation Marco...🎉🎉
    Waiting for Context transition video. 🕙

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

    Great explanation! Grade 1000 in 10!

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

    CARA MUITO BOM O VIDEO.. QUE QUALIDADE SENHORES... QUE QUALIDADE!!

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

    Very very important concept!!

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

    Great video, thanks

  • @bdog.69
    @bdog.69 24 дня назад +1

    Will the context transition article/video be released in the next 2 weeks? Thanks!

    • @SQLBI
      @SQLBI  24 дня назад

      It's coming later in September...

    • @bdog.69
      @bdog.69 22 дня назад +1

      @@SQLBI Thank you! 🤗

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

    😍

  • @sourabhpatel3834
    @sourabhpatel3834 14 дней назад

    Can we update numeric range parameter table in real-time based on the slicer applied on the page?
    I want to create a slicer ( between type) for % range , this should update based on slicers applied on our visual page
    Is it possible

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

    Any upcoming version in DAX Studio.... Sir

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

    Why are the Sales Amount Grouped totals different if Summarize preserves the same multiplication result, but simply collasped by the function?

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

      Can you clarify the question, please?

    • @bdog.69
      @bdog.69 24 дня назад

      At 19:25 of the video he explains how SUMMARIZE removes duplicated rows and so in this example 2 rows of (Quantity 2 x $15.92) ~ 2 x $31.84 = $63.68 becomes 1 row of (Quantity 2 x $15.92) = $31.84, thereby resulting in the lower total.

  • @vishwajeetghonmode7202
    @vishwajeetghonmode7202 29 дней назад

    Could you please give me solution,
    I have two tables charges and payment my requirement is payment comes month on month based on charge bill month.
    Suppose jan2024 charge billed $100 so $40 payment comes in jan2024 , $20 payment comes in feb2024, $15 comes in March 2024 and so on so. Bill ID is unique column in both table. How to calculate and show in matrix as
    Row
    Charge. Jan24. Feb24 mar24
    Jan2024. $40. $20. $15
    Feb2024. $60. $25
    Please give me solution in pawar bi.

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

    "Enjoy ducks"