49 - Playing with Summarize and max sales (DAX)
I called the work file "Double iteration" but it's been 1½ month since I made the original file.
The concept is loosely based on something I read in chapter 7 of "The definitive guide to DAX".
00:00 Intro
00:37 Preparation in Power BI
02:44 Page 1
03:50 Filter the date-filter
05:26 Max sale of each day (visualization)
07:11 Find the biggest sale
08:05 Find the salesperson with the biggest sale of each day
10:05 Slicer interactions
10:54 Page 2 - top performers
13:01 Page 3 - Day of max sales
13:44 Biggest sale
14:46 Manipulating data in Power Query
15:30 Max sale-date
16:34 ConcatenateX handles ties
17:42 Max sale-person
18:17 Fixing American dates with Format()