Перейти к содержимому

49 - Playing with Summarize and max sales (DAX)

WesleySon

0:00 / 0:00

49 - Playing with Summarize and max sales (DAX)

278 просмотров · 2 года назад
WesleySon
307 подписчиков
278 просмотров · 2 года назад
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()