Deprecated: Creation of dynamic property CF\WordPress\DataStore::$logger is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/DataStore.php on line 23
Deprecated: Creation of dynamic property CF\WordPress\Proxy::$pluginAPI is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/cloudflare/src/WordPress/Proxy.php on line 31
Deprecated: file_get_contents(): Passing null to parameter #2 ($use_include_path) of type bool is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/codelights-shortcodes-and-widgets/codelights.php on line 20
Warning: session_start(): Session cannot be started after headers have already been sent in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/wordpress/src/class/wordpress.php on line 53
Deprecated: Function jetpack_form_register_pattern is deprecated since version jetpack-13.4! Use Automattic\Jetpack\Forms\ContactForm\Util::register_pattern instead. in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-includes/functions.php on line 6078 August 2019 – Page 3 – Bonbon's Guide To Data & Tech
Practical Solutions for Excel, Power BI, SQL, Access, Python, Data Science, Automation & Other Tech
Month: August 2019
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
When looking to scale your work in Power BI, you want to understand how you can reuse DAX formula combinations throughout your model. The speed in which you can create detailed analysis is significant when you utilize these techniques.
I will be covering techniques such as cumulative totals, grouping, averaging, and more.
• How to scale your development w/ DAX
• How to quickly create compelling analysis
• Analyze trends and time-based information
• Learn to re-use similar combinations of formula
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
In today’s video I am going to show you how to reuse and modify your power bi Usage reports 🙂
This trick was shared by Kasper DeJonge here: https://ift.tt/2uXB0wH and there you will find the link to Gilbert’s post too. Enjoy!
You can download the pbix files here: https://ift.tt/2yGx9Ih and then community downloads number #50.
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://ift.tt/2NrgChB
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
With CALCULATE and CALCULATETABLE you have two of the most important functions in the entire DAX language. Understanding how these two functions operate is essential to any advanced analytical work in Power BI.
During this particular session, we will be drilling into the main differences between these two DAX formulas and also when it’s appropriate to use either one inside your calculated logic.
• Understand what CALCULATE does in-depth
• Start using CALCULATE correctly
• When to use CALCULATETABLE
• The main differences between these two functions
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
COUNTIFS($A$1:A1,A1) Formula in Power Query? – Excel Magic Trick 1588
Download Excel File: https://ift.tt/2OTCWpe
Learn how to create a Power Query Custom Column Formula that has an expandable range, counts based on the row condition and is equivalent to the Excel Worksheet Formula COUNTIFS($A$1:A1,A1). See how to use the Power Query Functions Table.AddColumn and Table.SelectRows. Also see how to create Two Custom Functions so we can access the Outside Table and Inside Table in the same formula.
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
To harness the analytical power behind Power BI, you really need to master DAX. DAX is the formula language which enables you to discover incredible insights into your data.
Throughout the session, we’ll be diving into some initial key concepts that you certainly will want to understand thoroughly when creating reports with Power BI. These include topics such as iterating functions, context, and measure syntax to name a few.
• Review the concept of context
• Iterating vs Aggregating functions
• Understand how DAX works w/ the data model
• How to structure and organize your measures
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
During this first session, we will be covering aspects of data modeling when working with multiple tables. Getting your model set up correctly in Power BI is absolutely essential to creating a scalable solution.
Enterprise DNA has many best practices to utilize in this particular area. Ideas around how to structure your model and also how to connect the right relationships between your tables.
• Learn how to optimize data
• Setup data model structure
• Relationship best practices
• Unique data model designs
• Working w/ multiple tables
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Here you can download all the pbix files: https://ift.tt/2yGx9Ih
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://ift.tt/2NrgChB
Many thanks in advance!
▲▲▲▲▲▲▲▲▲▲
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Download Excel File: https://ift.tt/2KoRI3i
5 different formulas to count the number of Saturdays in any month:
1. (00:01) Introduction
2. (00:43) SEQUENCE, EOMONTH, DAY, WORKDAY and SUM functions in one formula.
3. (03:04) SUMPRODUCT, ROW, INDIRECT, EOMONTH and WORKDAY functions in one formula.
4. (04:45) Bonus Formula #1, same as previous but rather than doing double negative to convert TRUEs and FALSEs to ones and zeroes, we use the mysterious N Function
5. (05:06) NETWORKDAYS.INTL and EOMONTH functions in one formula. Learn about Text String of ones and zeroes to indicate the Monday through Sunday days that are workdays and not workdays.
6. (06:25) Bonus Formula #2: Amazing Dynamic solution that is linked to cell so we can choose any day and count how many in a month. Same as previous but we use an Array Constant, the Not Comparative Operator, Double Negative and the CONCAT function in the weekend argument of the NETWORKDAYS.INTL function.
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
Download Excel File: https://ift.tt/2KoRI3i
Learn how to use a Dynamic Array Formula to increment numbers to create labels like: 1-6, 7-12, 13-18 and so on for Raffle Ticket Categories.
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
In today’s video I will show you what correlation is and how to calculate it in power bi, as well as show you the correlation custom visual. #powerbi #curbal #dax #daxfridays
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT
Here you can download all the pbix files: https://ift.tt/2yGx9Ih
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://ift.tt/2NrgChB
Many thanks in advance!Here you can download all the pbix files: https://ift.tt/2yGx9Ih
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
In today’s video I will show you what correlation is and how to calculate it in power bi, as well as show you the correlation custom visual. #powerbi #curbal #dax #daxfridays
Get Northwind Dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to EXCEL SURVEY: https://1drv.ms/xs/s!Ar8CDNp8cGTcgjaHonN82T8I1jQT
Here you can download all the pbix files: https://ift.tt/2yGx9Ih
SUBSCRIBE to learn more about Power and Excel BI!
https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
https://ift.tt/2NEZM2b
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: http://www.curbal.com
Contact us: https://ift.tt/2qhiZvU
▼▼▼▼▼▼▼▼▼▼
If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:
https://ift.tt/2NrgChB
Many thanks in advance!Here you can download all the pbix files: https://ift.tt/2yGx9Ih
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
– Join our DAX Fridays! Series: https://goo.gl/FtUWUX
– Power BI dashboards for beginners: https://goo.gl/9YzyDP
– Power BI Tips & Tricks: https://goo.gl/H6kUbP
– Power Bi and Google Analytics: https://goo.gl/ZNsY8l
************
What gear do I use to make my videos and run my business? Below you will find a list of most of my gear. The links on the store are affiliate links, meaning if you buy something from them, amazon will give a small commission and you will be supporting my channel indirectly. Thanks in advance!
Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64
REGISTRATION FOR THIS SUMMIT – https://ift.tt/2OPUJOe
FOR MORE DETAILS ON THE EVENT – https://ift.tt/2yMzfH9
Summit is free for all Power BI users.
EVENT DETAILS
Session 1 – Data Model Design Best Practices
Learn how to optimize data
Setup data model structure
Relationship best practices
Unique data model designs
Working w/ multiple tables
Session 2 – DAX Fundamentals
Review the concept of context
Iterating vs Aggregating functions
Understand how DAX works w/ the data model
How to structure and organize your measures
Session 3 – CALCULATE vs CALCULATETABLE
Understand what CALCULATE does in-depth
Start using CALCULATE correctly
When to use CALCULATETABLE
The main differences between these two functions
Session 4 – DAX Formula Combinations
How to scale your development w/ DAX
How to quickly create compelling analysis
Analyze trends and time-based information
Learn to re-use similar combinations of formula
Session 5 – Budgeting Techniques
Learn to deal w/ data at different granularity
Manage a more complex data model
Learn how to create virtual relationships using TREATAS
Review Actuals vs Targets overtime
Session 6 – Optimizing DAX Formulas
Learn to structure your formulas correctly
Master the proper syntax and best practices for measures
Understand why your formula is working slowly
Learn auditing techniques to optimize your measures
Understands more deeply how formulas are calculated