Рет қаралды 72
Russian version of this video @pbi-vlog ➡️ • SQL vs DAX: 12 запросо...
If you are more or less fluent in SQL and want to get better in DAX, this video is just what the doctor ordered.
PDF document with all the queries from the video ➡️ disk.yandex.ru/i/fVfZY-wR0Qbi0A
***
00:00 Intro
01:11 Warm Up
01:56 TOPN
02:17 EVALUATE TABLE
02:37 VALUES / DISTINCT
03:05 Aggregate Functions
04:55 FILTER
05:56 SUMMARIZE
06:39 FILTER x 2
07:21 Auxiliary Tables
08:03 NATURALINNERJOIN
09:47 NATURALLEFTOUTERJOIN
10:07 UNION
11:09 RANKX
12:31 Afterword