3 Months Rolling Total in Power BI | How to calculate 3 months rolling total in Power BI |

แชร์
ฝัง
  • เผยแพร่เมื่อ 31 ม.ค. 2025

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

  • @sureshkumar3015
    @sureshkumar3015 17 วันที่ผ่านมา

    Great explanation bro

  • @nicholasgyimah244
    @nicholasgyimah244 10 หลายเดือนก่อน +1

    Very lucid and clear.
    Thank you🎉

    • @learningsciencetech
      @learningsciencetech  10 หลายเดือนก่อน

      You're welcome 😊 Please also explore below video. I hop you will link it. This was new concept release by Microsoft in Feb 2024.
      Visual level calculations using template without writing DAX measures in Power BI
      th-cam.com/video/Mo06fhn4bfQ/w-d-xo.html
      Request u to pls subscribe to my channel to learn more about #PowerBI #PowerQuery #DAX & also to like & share. If you find the content helpful, you can also support me by buying a coffee-just click the 'THANKS' button below the video

  • @allenryder
    @allenryder 4 หลายเดือนก่อน

    Perfect Thank You So Much

    • @learningsciencetech
      @learningsciencetech  4 หลายเดือนก่อน

      You are very welcome. Many .... thanks for your blessing
      Please subscribe to my channel to learn more about #PowerBI, #PowerQuery, and #DAX if you haven't subscribed yet. Don’t forget to like and share. You can also buy me a coffee-just click the 'THANKS' button below the video.
      You can also watch our below video:
      Visual level calculations using template without writing DAX measures in Power BI
      th-cam.com/video/Mo06fhn4bfQ/w-d-xo.html

  • @GuidoWiertz
    @GuidoWiertz 11 หลายเดือนก่อน +1

    Very clear explanation. Question though: How can you add a 3 months running total for (various) categories?

  • @GuidoWiertz
    @GuidoWiertz 11 หลายเดือนก่อน +1

    Another question popped up (in addition to below question I posted yesterday). What to do with a 3 months total, for months where there is no data for? I would expect the 3 months total being the total of "month" + "month-1" + "month-2". And when there is no data in "month", I would expect for this month to see the total for "month-1" + "month-2". But somehow, I do not get a 3 months total for months without data. They are blank

    • @learningsciencetech
      @learningsciencetech  11 หลายเดือนก่อน

      Give us some time we will get back to you.

    • @learningsciencetech
      @learningsciencetech  9 หลายเดือนก่อน

      Hello, thank you for watching. I am sharing another video. I hope you are interested. Please check the link below.
      Calculate a running sum or total at visual level without using DAX measures
      th-cam.com/video/cQLu9PXQNIc/w-d-xo.html
      Request u to pls subscribe to my channel to learn more about #PowerBI #PowerQuery #DAX & also to like & share. You can also support me by buying a coffee-just click the 'THANKS' button below the video.

  • @GuidoWiertz
    @GuidoWiertz 11 หลายเดือนก่อน +1

    Any update on the below help requests? Would be much appreciated. Thanks in advance!

    • @learningsciencetech
      @learningsciencetech  11 หลายเดือนก่อน

      Give us some time we will get back to you on this.

    • @learningsciencetech
      @learningsciencetech  10 หลายเดือนก่อน

      th-cam.com/video/Mo06fhn4bfQ/w-d-xo.html

    • @learningsciencetech
      @learningsciencetech  9 หลายเดือนก่อน

      Hello, thank you for watching. I am sharing another video. I hope you are interested. Please check the link below.
      Calculate a running sum or total at visual level without using DAX measures
      th-cam.com/video/cQLu9PXQNIc/w-d-xo.html
      Request u to pls subscribe to my channel to learn more about #PowerBI #PowerQuery #DAX & also to like & share. You can also support me by buying a coffee-just click the 'THANKS' button below the video.

  • @shahnidk2288
    @shahnidk2288 11 หลายเดือนก่อน +1

    Hi, how can we calculate average of the same concept.
    Need to get the average with 3 months interval. For jan 2019 it should show the same value. For feb, jan + feb by 2. For march jan + feb + march by 3. And from march onwards it should calculate for 3 months.
    Thanks in advance.

    • @learningsciencetech
      @learningsciencetech  11 หลายเดือนก่อน

      Hello,
      Use the AVERAGE DAX function instead of SUM.

    • @learningsciencetech
      @learningsciencetech  9 หลายเดือนก่อน

      Hello, thank you for watching. I am sharing another video. I hope you are interested. Please check the link below.
      Calculate a running sum or total at visual level without using DAX measures
      th-cam.com/video/cQLu9PXQNIc/w-d-xo.html
      Request u to pls subscribe to my channel to learn more about #PowerBI #PowerQuery #DAX & also to like & share. You can also support me by buying a coffee-just click the 'THANKS' button below the video.