Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Average by Product and Week Type

Hello Team,   I apologize if this question has already been addressed, but I haven't been able to find a solution. I've been struggling with this issue for the past couple of days and it's causing ...
  • DataNinja777's avatar
    DataNinja777
    2 years ago

    Hi Anonymous ,

    Thank you for your feedback.  I've redone the calculated column to produce your required output.  

    I also attach the pbix file as an example.  

    Best regards,

DataNinja777's avatar
DataNinja777
Icon for Super User rankSuper User
2 years ago

Hi Anonymous ,

 

Are you trying to calculated the weigted average of the products over different weeks?  In that case, it can be calculated in the following mannter as an example.  

 

If you you required output is different one, please let me know. 

I attach an example pbix file.  

Best regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi,

     

    Thanks for looking on this. Unfortunately this is not what I'm looking for. I need result exactly as in column [Average per Product on SHELF WEEK]

    • DataNinja777's avatar
      DataNinja777
      Icon for Super User rankSuper User
      2 years ago

      Hi Anonymous ,

      Thank you for your feedback.  I've redone the calculated column to produce your required output.  

      I also attach the pbix file as an example.  

      Best regards,