Month: October 2022


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

Make Q&A more effective in Power BI

Posted on by Annie D

Most struggle with getting Q&A to be effective in Power BI. Usually this comes down to either model naming or synonyms. Patrick shows you how you can update these and also a nice feature to let you share them with others.

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— Continue reading “Make Q&A more effective in Power BI” →


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

Easy Variance Charts in Excel With Zebra BI For Office – 2525

Posted on by Annie D

Your Excel charts should always show a variance. Maybe a variance from plan or a variance from last year. A new Excel (and PowerPoint) tool from Zebra BI makes this very easy.

Links from the video:
IBCS Standards: https://www.ibcs.com/ibcs-standards-1-2/
About Zebra BI: https://bit.ly/3D0hipe
The free templates from Zebra BI: https://bit.ly/3zeLiws

Table of Contents
(0:00) Life-changing
(0:29) Excel Chart
(0:58) ICB Standards
(1:29) Some ICBS rules
(2:18) Zebra BI for Office
(3:14) Creating chart in Zebra BI
(3:52) Interpreting Chart
(5:14) Second chart
(6:06) Formatting
(7:01) Free templates
(7:15) Wrap-up


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

Excel Mystery – What Could Be Causing Rogue Line At Bottom of One Cell? #shorts

Posted on by Annie D

Excel Mystery: Someone reports they have 7 cells with data. One of them has a mystery line at the bottom of the cell. It is not a border. What else could it be?


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

Using ALLSELECTED – DAX Formula Concepts In Power BI [2022 Update]

Posted on by Annie D

ALLSELECTED is a complex DAX function in Power BI. In this tutorial, Sam shows how to use this function when creating calculations in Power BI and get to understand the difference between the ALL and ALLSELECTED functions in DAX.

***** Video Details *****
00:00 Introduction
00:28 What is ALLSELECTED
00:46 Using ALLSELECTED in Cumulative Sales
01:59 Difference in context between ALLSELECTED and ALL
03:00 Visualization of ALLSELECTED vs ALL
04:24 Using ALLSELECTED in SUMX

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE Continue reading “Using ALLSELECTED – DAX Formula Concepts In Power BI [2022 Update]” →


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

Deneb Cheat Sheet For Power BI – FREE Download

Posted on by Annie D

Deneb is a pretty awesome visual tool for folks who want more visualization opportunities in Power BI aside from the native visuals.

As Deneb is code-based, familiarity will be a helpful thing. So to get the most out of Deneb and to make learning easier, our Deneb master, Greg Philps, has developed a cheat sheet that you can conveniently refer to. Watch as Greg gives an extensive demo on what you can expect from this cheat sheet.

The Deneb Cheat Sheet for is available for FREE to Enterprise DNA subscribers.

Download the Deneb Cheat Sheet here: https://www.enterprisedna.co/power-bi-resources

***** Learning Continue reading “Deneb Cheat Sheet For Power BI – FREE Download” →


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

Excel Random Date or Random Date and Time – 2524

Posted on by Annie D

How to generate random dates in Excel.
How to generate random date and time in Excel.

Table of Contents
(0:00) Welcome
(0:34) Random Date in Excel
(2:38) Random Time in Excel
(3:01) RandomTime During the Workday in Excel
(3:58) Random Time to nearest quarter hour
(4:45) Random Date /Time in Excel
(5:36) Random Weekday in 2025 in Excel
(6:44) Random Weekday No Holidays in Excel
(7:45) Randomly Choose a Monday or Thursday in Excel
(9:19) Randomly Choose particular weekdays in Excel
(10:35) Wrap-Up


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

MrExcel Favorite Excel Spreadsheet – Arranging Player Piano Rolls

Posted on by Annie D

A look back to the early days of Tickling Keys, Inc. – when our main product was rock and roll player piano rolls. This is my favorite spreadsheet. What is yours? #ExcelAtEverything

Thanks to video footage from David Shivers at the Salem (Ohio) Historical Society.


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

Deneb Cheat Sheet For Power BI – FREE Download

Posted on by Annie D

Deneb is a pretty awesome visual tool for folks who want more visualization opportunities in Power BI aside from the native visuals.

As Deneb is code-based, familiarity will be a helpful thing. So to get the most out of Deneb and to make learning easier, our Deneb master, Greg Philps, has developed a cheat sheet that you can conveniently refer to. Watch as Greg gives an extensive demo on what you can expect from this cheat sheet.

The Deneb Cheat Sheet for is available for FREE to Enterprise DNA subscribers.

Download the Deneb Cheat Sheet here: https://www.enterprisedna.co/power-bi-resources

***** Learning Power Continue reading “Deneb Cheat Sheet For Power BI – FREE Download” →


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

Excel Create Random Order #shorts

Posted on by Annie D

Sort a list into random sequence.
Can Excel Randomly Sort Data?
Excel Create Random Order?
Excel Random Sort?
Can Excel Randomly Sort Data?
Excel How To Random Sort?
Excel Random Order?
Excel Random Order List?
Excel Random Row Order?
Excel Create Random Order?


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

Excel Random Sample From A List – #shorts

Posted on by Annie D

Excel random sample?
Excel random sample without replacement?
Excel how to random sample?
Excel random selection from list?
Excel random selection from list no duplicates?
Excel random row selection?
Excel random cell selection?
Excel random list selection?
Is there a random selection function in excel?
Can Excel randomly select from a list?
Can Excel randomly select rows?
Using Excel random selection?
Can Excel make random selections?


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

Excel Randomly Choose Yes Or No #Shorts

Posted on by Annie D

Excel randomly choose Yes or No.
Use CHOOSE and RANDBETWEEN for a roughly 50/50 split.
Or use IF and RAND to generate an approximate percentage of one or the other.


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

Excel Random Male Or Female #shorts

Posted on by Annie D

How can you randomly choose between male or female in Excel?
Randomly choose gender in Excel?
Excel randomly choose between two items?