Forum Discussion

PC2790's avatar
PC2790
Community Champion
4 years ago
Solved

Weekday having maximum average sales

Hey,

 

I am trying to get the weekday having maximum average of sales in my orders table.

This is irrespective of year and month, just the weekday.

 

I am trying this:

BestSellingWDonAverage =
var maxaverage = Maxx(SUMMARIZECOLUMNS(DatesTable[DayOfWeekName],"AvgSales",MeasuresTable[AverageSales]),[AvgSales])
return maxaverage
 
but this is giving me nothing by "Wednesday" base don the alphabet W.
Data attached for reference.
 
Need Help

5 Replies

  • Rakia's avatar
    Rakia
    Regular Visitor
    3 years ago

    hello!

    How Can we show just the value of the average sales of a specific day ?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      Hi,

      Share some data, describe your question and show the expected result.