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 ...
DAX AVERAGE
  • 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,

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,