cancel
Showing results for
Did you mean:
Helper V

## Best Selling Day

I have a table which contains Product,Sales and Date column.

I want to create a measure which will give me the best selling day for the particular product.

My table has values like,

 Product Sales Date Dell 20000 14-06-2021 HP 45555 20-01-2020 Toshiba 68888 12-08-2020

I first created a measure for Average Sales Per day using

Average Sales Per Day =
AVERAGEX(VALUES(Sheet1[Date].[Date]),[Total Sales]).

I know that we have to make use TOP N DAX, but I am not able to figure out a formula for the same.

If someone can help, then do please let me know.

Regards,
Sanket Bhagwat
1 ACCEPTED SOLUTION
Helper V

Okay, I have solved this thing.

1)I first created a measure for 'Average Sales per Day" as

Average Sales Per Day =

AVERAGEX(VALUES(Sheet1[Date].[Date]),[Total Sales]).

2)Then I calculated 'Best Selling Date' as,

Best Selling Date =
MAXX(
TOPN(1,
SUMMARIZE(Sheet1,Sheet1[Date].[Date],
"Selling Days",[Average Sales Per Day]),
[Selling Days]),
Sheet1[Date].[Date]
)
Here I got the best selling date and not the actual Date.

3)So I converted it into dddd format as

Best Selling Day =
FORMAT([Best Selling Date],
"dddd")
This gives me the Best Selling Day.

Regards,
Sanket Bhagwat.

If this post helps, then please mark it as 'Accept as Solution".

2 REPLIES 2
Helper V

Okay, I have solved this thing.

1)I first created a measure for 'Average Sales per Day" as

Average Sales Per Day =

AVERAGEX(VALUES(Sheet1[Date].[Date]),[Total Sales]).

2)Then I calculated 'Best Selling Date' as,

Best Selling Date =
MAXX(
TOPN(1,
SUMMARIZE(Sheet1,Sheet1[Date].[Date],
"Selling Days",[Average Sales Per Day]),
[Selling Days]),
Sheet1[Date].[Date]
)
Here I got the best selling date and not the actual Date.

3)So I converted it into dddd format as

Best Selling Day =
FORMAT([Best Selling Date],
"dddd")
This gives me the Best Selling Day.

Regards,
Sanket Bhagwat.

If this post helps, then please mark it as 'Accept as Solution".

Responsive Resident

Hello @SanketBhagwat

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.