Moving Averages / Rolling Averages in Power BI DAX Tutorial (28/50)

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

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

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

    Excellent....to resolve smoothly without writing complete dax instead using quick measure

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

    Hi ,
    Your Videos are really great. Thank you for this...I have one question on Measures. Suppose in one report there are two measures , one created using Quick measure option and another using New measure(Manual DAX exntry), How do I differentiate them...Also for quick measure one , how do we know which calculation is used while creating it?

  • @jananiingarshal1777
    @jananiingarshal1777 2 года назад +1

    Very well explained and I tried for 3 months rolling average and got the correct output. But getting total column as well.. please let me know how we can remove the total

    • @AnalyticswithNags
      @AnalyticswithNags  2 года назад +1

      In table properties uncheck total column

    • @jananiingarshal1777
      @jananiingarshal1777 2 года назад

      @@AnalyticswithNags Thanks for the response and let me check this option

  • @gagansingh3481
    @gagansingh3481 2 года назад +1

    Your measure is awesome easily understable ....Sir

    • @AnalyticswithNags
      @AnalyticswithNags  2 года назад

      Thanks keep learning share this channel with friends and colleagues

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

    I have constantly followed your video and subscriber too.
    I have learned SQL, PowerBI from your video. Thank you for your Hardwork.
    One question, How can i filter the data as in the current example its showing data from january 2016 to April 2017. I want to show only past 5 months data in the graph.
    The issue arising is after filtering past 5 months i.e. from December 2016 to April 2017 again for the month of Dec., 2016 the rolling average will be 169250 instead of 164017 because the past months are filtered but i need the 3 month rolling average for December 2016 i.e. 164017 .

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

      this video may me helpful for you - showing how to create rolling average for the past 5, 6, 7 months etc depending on user selections.

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

      yes

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

    Calculate (average (sale amount), datesinperiod(date column, date,-3, month)

    • @AnalyticswithNags
      @AnalyticswithNags  8 месяцев назад

      Check playlists of this channel and explore topics on the similar line requested by you.

  • @mudigubbasachivalayam1368
    @mudigubbasachivalayam1368 2 года назад +1

    your videos are very helpful,
    i got some issue, my date column contains month starting from july 2014 but my moving average is considering from january 2014, it is including months form january to june(it is not part of my data), can you tell me what might be the problem.

  • @raghu4780
    @raghu4780 3 года назад

    l am getting values in rolling average similar to month sales, in that case how it should be over come

  • @prashantburman4026
    @prashantburman4026 2 года назад +1

    Is it possible for 3 days moving average?
    please help me

  • @Ashok2293
    @Ashok2293 3 года назад

    Can you explain about average and averagex

  • @venkatareddykummitha5863
    @venkatareddykummitha5863 3 года назад +1

    do a simple average calculations

    • @AnalyticswithNags
      @AnalyticswithNags  3 года назад

      Will do soon.
      Meanwhile
      You can try by changing the aggregation from sum to average

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

    Thanks