Month: October 2022

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” →

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

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]” →

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” →

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

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.

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” →

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?