PRACTICAL WAYS to use the WINDOW function in Power BI // Beginners Guide to Power BI

Поделиться
HTML-код
  • Опубликовано: 26 ноя 2024

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

  • @navisalomi
    @navisalomi Год назад +1

    Window functions are easy if you've done some SQL before. Otherwise, think of it like Excel Absolute and relative reference when calculating cummulative total like SUM($A$1:A2).
    The major catch being the PartitionBy which revs the power up by more than 100 😅.

  • @pupycron4302
    @pupycron4302 Год назад

    Excellent explanation!

  • @amirhd2080
    @amirhd2080 Год назад

    Thanks for simplify way to understanding windows function 😊

  • @vasudeva2957
    @vasudeva2957 Год назад

    Thanks for this scenario based window function

  • @MatheusPassaura
    @MatheusPassaura Год назад

    Great content

  • @wbtwarmerdam
    @wbtwarmerdam 8 месяцев назад +1

    The absolute and relative is like the $ in excel, when you “drag” a window. That’s how I “framed” it in my mind

  • @emilymalkin270
    @emilymalkin270 7 месяцев назад

    Thank you 👍🏻👍🏻👍🏻👍🏻

  • @cescodeidda277
    @cescodeidda277 11 месяцев назад

    Thank you for this tutorial, but could explain why with me it works differently ? :
    Highest Selling Month by Year =
    MAXX(
    WINDOW(
    1, ABS, // start of the window
    -1, ABS, // end of the window
    SUMMARIZE(ALLSELECTED('Maven Cycles Calendar'), 'Maven Cycles Calendar'[Year], 'Maven Cycles Calendar'[Month Number]), , ,
    PARTITIONBY('Maven Cycles Calendar'[Year])
    ),
    [Total Quantity]
    )
    returns the exact same value that Total Quantity" column (Start of Month row - e.g. "January 2015, February 2025....")

  • @shreyoshiraychaudhary8808
    @shreyoshiraychaudhary8808 5 месяцев назад

    Window = MAXX(
    WINDOW( 1,ABS,-1,ABS,
    SUMMARIZE(
    ALL('Calendar'),'Calendar'[Month_Name],'Calendar'[Year_ID]
    )
    ,,,PARTITIONBY('Calendar'[Year_ID])),
    [Customer Sales]
    )
    This is not working for me. Can you please check if dax is right or not?

    • @sr5726
      @sr5726 4 месяца назад

      month name should be sorted by month number. include that under SUMMARIZE(ALLSELECTED('Calendar'),Calendar'[Year_ID], 'Calendar'[Month_Name], 'Calendar'[Month_Nmber] )

  • @bingjohniken8363
    @bingjohniken8363 Год назад

    'promo sm' 😡