Optimizing LASTNONBLANK and LASTNONBLANKVALUE calculations

แชร์
ฝัง
  • เผยแพร่เมื่อ 29 ต.ค. 2024

ความคิดเห็น • 15

  • @gregoryoliveira8358
    @gregoryoliveira8358 ปีที่แล้ว +2

    This video helped me to author my first advanced semi-additive measure: warehouse amount monthly. :-) Thanks for your great material and support.

  • @BernatAgulloRosello
    @BernatAgulloRosello 3 ปีที่แล้ว +3

    Still struggling to imagine different ways of getting the same result, but I am getting better only by watching your videos. For me it's definately one of the few good things this pandemic has enabled

  • @HeliSal700
    @HeliSal700 3 ปีที่แล้ว +1

    The right video at the right time.
    I have to solve a similar challenge for my customer today.
    Thank you

  • @pedrobaltazargonzalez4281
    @pedrobaltazargonzalez4281 2 ปีที่แล้ว +1

    You are amazing!
    thanks for sharing your knowledge. Un saludo desde El Salvador, Centroamerica

  • @mnowako
    @mnowako 3 ปีที่แล้ว +1

    Again, excellent lesson. Your videos are second to none. Can you please make videos every working day? That would be awesome 👍

  • @lmblancoancos
    @lmblancoancos 3 ปีที่แล้ว +1

    Thank you Alberto. Awesome!!! as all your optimizing videos

  • @Bharath_PBI
    @Bharath_PBI 3 ปีที่แล้ว +1

    Very useful info. Enjoying DAX! Thank you 👍

  • @rdg515
    @rdg515 2 ปีที่แล้ว +1

    Great video!

  • @santoshraghunath8133
    @santoshraghunath8133 3 ปีที่แล้ว +1

    Hi Alberto, thanks for all the videos you make. One question out of syllables - which camera you use, it looks so good.

    • @SQLBI
      @SQLBI  3 ปีที่แล้ว

      Read here: www.sqlbi.com/blog/alberto/2021/02/14/on-my-recording-gear/

  • @teigenxayden
    @teigenxayden 6 หลายเดือนก่อน +1

    excerllent video!

  • @ashishmohan4707
    @ashishmohan4707 3 ปีที่แล้ว +1

    Hi Alberto
    very useful video and very practical need everyone for every project ......very big thanks to share with us.
    Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
    But due to my humble request can you plzz cover basic to advance level of RLS

  • @Fernando_Calero
    @Fernando_Calero 2 ปีที่แล้ว

    I'm struggling because my Previous Date measure returns blank... I have a Calendar table with a 1:N relationship to the Sales table in order and followed exactly. 😕

    • @Fernando_Calero
      @Fernando_Calero 2 ปีที่แล้ว +1

      I've got it. I was using the Sales date in the table visual instead of the dimension date.

  • @wisa7615
    @wisa7615 3 ปีที่แล้ว

    Oke, why not use allselected on date column, because allselected removes any filter inside the query