For my first tutorial, I’ll show you how to optimize a Power BI report with slow measures for an incentive plan that involves thorough SWITCH statements. This is part of Enterprise DNA’s new initiative called Optimization Lab, wherein we ask our members to send in their slow-running reports so we can try and see how to optimize and identify where the bottleneck is happening.
Antriksh
Links mentioned in the video:
Slow Measures For Incentive Plan Setup at the Enterprise DNA Forum -
***** Video Details *****
00:00 Introduction
01:00 The data model
02:29 Date closed filter
02:46 Job list filter
03:15 Matrix visual
04:00 Test running the code
05:36 Main measures
07:05 Incentive %
11:50 IF vs SWITCH statements
13:40 How codes are executed
15:42 Strict evaluation
18:32 Eager evaluation
20:05 Benefits of using eager evaluation
21:15 When to use strict evaluation
23:47 function
25:52 Key takeaways
30:59 ISINSCOP
1 view
1710
510
2 days ago 00:03:47 1
SCOOTER - HOW MUCH IS THE FISH (Metal cover)
4 days ago 00:20:57 1
Incredible Discovery In The Grand Canyon? - YouTube
4 days ago 00:29:11 1
Interview with Valentin Kozlov, Valmix Company | Potato Tour Across Russia (Part 2) 🥔🚜
6 days ago 00:57:54 1
Lost In Time : The Isolated House Where She Lost Her Mind | How I Find Abandoned Placess
6 days ago 01:01:39 1
TIME SLIP STORIES (SN 18 EP 38) TRUE UNEXPLAINABLE EXPERIENCES WITH MISSING TIME & TIME SLIPS
7 days ago 00:00:31 2
How To Train Your Dragon | Big Game Spot
7 days ago 00:05:05 59
How to Clown - Misha Usov - Professional Clown School
1 week ago 00:38:45 2
Try Not To Laugh Challenge#7 | Instant Regret Fails Compilation 2024 | Amazing People
1 week ago 00:29:31 1
Membership Perks
1 week ago 07:10:32 1
У края бездны-(2024) все серии 1-4. Освобождение Мариуполя.Причитайте ограничения в описании ниже!!
1 week ago 00:08:00 16
Dream Theater - Midnight Messiah (Official Video)
1 week ago 00:05:14 2
Clara Fernández: The Spanish Sensation Transforming Pole Vaulting
1 week ago 00:27:54 5
Секретные космические лазеры устраивают пожары на Земле?
2 weeks ago 01:18:02 2
The Spider’s Web: Britain’s Second Empire | The Secret World of Finance
2 weeks ago 00:03:57 46
Britney Spears - ...Baby One More Time (Official Video)
2 weeks ago 00:17:09 1
Blouse crochet pattern - how to crochet summer top
2 weeks ago 00:15:40 1
Как вязать росток кардигана Вязание укороченными рядами How to knit a cardigan back height
2 weeks ago 00:04:50 20
In The Army Now (Status Quo) • Drum Cover
2 weeks ago 00:38:56 2
Time Team Podcast | New excavations at Pompeii
2 weeks ago 00:56:53 3
DOGMAN, MIRRORED MEN AND HIGHWAY GHOSTS: TALES FROM THE ROAD (SN 18 EP 36) TRUE SPOOKY STORIES
2 weeks ago 00:15:46 2
🐹 КРОТЫ УХОДЯТ НАВСЕГДА! Как прогнать кротов с участка дымовой самодельной шашкой
2 weeks ago 01:12:12 1
Crochet Lacey Vest Tutorial | Chenda DIY
2 weeks ago 00:09:56 1
Mother Tucker: The Donald Trump & Jared Kushner Family Business Suckled From The Tit Of Saudi Arabia
2 weeks ago 00:18:46 1
I Crocheted a Houndstooth Vest | Pattern Walk-through