Weekday having maximum average sales

[PC2790]

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.

[Rakia]

hello!

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

[Ashish_Mathur]

Hi,

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

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[PC2790]

Great!

I knew it needed a fresh set of eyes

Thankyou

[Ashish_Mathur]

You are welcome.