Forecasting Measure in Power BI

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

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

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

    Thanks for the great video! How would you extend the forecast line to go beyond the actual lines? I am attempting to create this on a monthly level, so that there would be one historical/cumulative line that would illustrate a lower value for the current month as compared to the EOM value in the forecast line. Thanks!

  • @mmtindaro742
    @mmtindaro742 3 года назад +2

    pretty good thanks , I do generally run same but with max , min & average forcast in your end variable + a manual factor that works as pull or push depending the situation . Thanks again

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

    In some paper they have asked
    Which is not a forecasting technique
    Regression
    Time series
    HOLT & WINTER method
    Exponential smoothing
    Which option I need to select ??

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

    Awesome measure. I will be utilizing this everywhere.

  • @simonloughnane6683
    @simonloughnane6683 3 года назад +3

    Very interesting, thank you. Amazing what can be achieved with a few lines of DAX.

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

    Hi,in my scenario i want to calculate forecast value based on previous month value and want to display from Jan to dec .suggest me dax formula

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

    Do u calculate saisonality how ?

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

    Hello, how do I verify the prices of competitors products through their websites on Power BI? For example, a supermarket site or a site that sells infoproduts?

    • @KnowledgeBankPro
      @KnowledgeBankPro  3 года назад +2

      you will need to look into page scraping technics using python or something, this is not strictly speaking something power bi can natively do. Also, be aware that your competition most likely will not like you scraping their pricing information, etc

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

      @@KnowledgeBankPro Thank you :)

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

    Thanks. That's great code. Even Alberto Ferrari would be impressed with that 👍

  • @ВладимирИваненко-е6у

    that's a great video, thank's you for such a detailed explanation

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

    Hello, I am struggling to plot a lower bound and upper bound using standard deviation. It would be great if you can help me in this.
    Thanks in advance ☺

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

    Great content as always.

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

    I have to say this forecast is not very good at all for generic use.
    I appreciate you sharing your implementation, but there is so many assumptions that make it not useful for other use cases at all
    In essence you are doing a time series forecast, but:
    - the deathgrowth assumes a YoY increase in trend, since you are using the max deaths and min deaths to calculate the trend
    - the measure only works for 2020 since you hardcoded the year
    - your concept of seasonality and trend is the same in your example
    thank you!