Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Average Sales DAX code

Dear Experts

 

I have the below report being used by the business. I was asked to populate the average of total sales of all stores of group A for a particular week.

 

I do not have date in my dataset, there is only weekyear, month and year.


Can anyone please help me with the DAX code to achieve the average sales for a particular week.

 

Thanks
Mahad

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    3 years ago

    Anonymous 

    Give this a try.

    Avg =
CALCULATE (
    AVERAGE ( YourTable[Sales] ),
    ALLEXCEPT ( YourTable, YourTable[Week], YourTable[Group] )
)

     

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    3 years ago

    Anonymous 

    Give this a try.

    Avg =
CALCULATE (
    AVERAGE ( YourTable[Sales] ),
    ALLEXCEPT ( YourTable, YourTable[Week], YourTable[Group] )
)