Forum Discussion

richardburling's avatar
richardburling
Helper I
1 year ago

Exponential Weighted Moving Average without Time Intelligence

Good Morning,   I hope you are all well. 😁   I have been trying to calculate you a Exponential Weighted Moving Average based on sales data, but unfortunately I dont have calendar date in my data...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi richardburling 

Please find the attached PBIX file below for your reference

Thanks,
Pavan

richardburling's avatar
richardburling
Helper I
1 year ago

Hi danextian thank you for sending across the pbix to me. I have tried replicating your method within my dataset but it doesnt seem to work. I think it may be due to the recursive part of the EWMA formula, where the later part is looking back at the previous EWMA to calculate the current value. I'll keep trying to find a solution. 

 

Based on my research my dataset seems quite different to how others are using Power BI. The dataset I have is created by 20 tables being pulled from a database made up of both DIM and FCT tables which are joined on a unique key. Most people seem to have their data self contained in one spreadsheet. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi richardburling,

    I wanted to follow up, We hope your issue has been resolved.
    If the community member's answer your query, please mark it as "Accept as Answer" and select "Yes" if it was helpful.

    If you need any further assistance, feel free to reach out.

    Thanks,
    Pavan.