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()
Watch video 49 - Playing with Summarize and max sales (DAX) online without registration, duration hours minute second in high quality. This video was added by user WesleySon 30 October 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 123 once and liked it 3 people.