October 17 is Spreadsheet Day – marking the anniversary of the release of VisiCalc on October 17, 1979. In this short video, an actor does an amazing job of playing Sheriff Buford T. Justice, the role made famous by Jackie Gleason in the Smokey and the Bandit movies.
Have a happy spreadsheet day!
Today, October 17, 2022 is International Spreadsheet Day. Microsoft has asked a lot of creators to post their favorite Excel tips. Here is mine: Double-click the Fill Handle to copy a formula to the bottom of the data.
Jamaican Reggae Legend Willie Dickson of Willie Dickson and the Playboys wishes everyone a happy spreadsheet day and then dazzles us with drum rendition of the Rasta Beat.
Background vocals by Dickson’s Russea’s High School schoolmate Llewelyn Grant.
Special performance for spreadsheet day by a legendary drummer and one of the godfathers of Reggae and a legendary drummer.
Funny story: When I first heard of Willie Dickson, I confused him with Chicago blues legend Willie Dixon who has passed away. Our Willie Dickson tells of meeting Willie Dixon on the road in Montreal one time when they were Continue reading “Reggae Pioneer Willie Dickson Plays for Spreadsheet Day”
October 17, 2022 is spreadsheet day. For all of you who can pivot data as quickly as Nate “Big Easy” Lofton can spin a ball on his finger, Happy Spreadsheet Day! #Globetrotters #HarlemGlobetrotters #HappySpreadsheetDay
Today – October 17 is SPREADSHEET DAY! This marks the anniversary of the October 17, 1989 release of the first spreadsheet – VisiCalc. For any #StarTrek fans out there, we have a cool spreadsheet day message from Lt. Commander Shelby. I should have asked if #Excel was still the dominant spreadsheet in the future.
In this video, Melissa is going to give a walkthrough on her approach for Bhavya Gupta’s Power Query Challenge involving Conditional Indexing. The task is to add an index number from 1 for each ID in the table and begins in the row after the values in the date columns hit more than or equal 90.
Link to the Power Query Challenge: https://bit.ly/3T9XBSJ
***** Video Details *****
00:00 Introduction
00:57 Group By
02:43 Table.RowCount
02:56 List.PositionOf
04:54 Generic list
06:00 List.Repeat
06:40 Restricting elements
07:50 Contstruct table
09:20 Expand nested tables
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – <a Continue reading “How To Add A Conditional Index In Power Query”
It’s been 4 months since I have posted a skatepark BMX and Skateboard video. This was rad fun on Sunday, Oct. 16, 2022 at Delridge Skatepark and Jefferson Skatepark with Isaac “Iceman” Girvin and Mike “excelisfun” ‘Magic” Girvin.
This is the best way to get fuel to make Excel videos and write Excel books during the week : )
The Boneless Ones Skate Punk Band Song Back To The Grind pumps the action and creates rad!
Washington BMX / Skate Adventure 17.
In this video, Jarrett is going to show how to use Power Automate Desktop to add a date to a filename.
Enterprise DNA Forum Post: https://forum.enterprisedna.co/t/refreshing-and-excel-file-in-sharepoint-w-power-automate/28162
***** Video Details *****
00:00 Introduction
01:35 The problem
02:20 Getting current date and time
02:58 Converting datetime to text
04:01 Renaming file
05:26 Running flow
***** 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 – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download Continue reading “How To Add Date To Filename In Power Automate Desktop”
Join us live as we answer your questions about Power BI!
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)
📢 RULES FOR Q&A: 📢
👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout
📢 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 Continue reading “🔴 Power BI tips from the Pros – LIVE (Oct 15, 2022) (Member Chat 2nd Half)”
How to split delimited into rows.
I tried using Power Query.
With Power Query I can do it only for 1 column.
If I select more than 1 column, the Split Column is disabled in the Power Query Editor.
Is there any other solution for splitting delimited into rows for more than one column?
This video offers three solutions.
Solution 1 is a formula such as =TEXTJOIN(“|”,,TEXTSPLIT(C2,”,”)&”-“&TEXTSPLIT(B2,”,”)) and then Power Query.
The 2nd solution is M code written by Suat Ozgur. Get that code from MrExcel:
https://www.mrexcel.com/board/threads/power-query-split-to-rows-for-2-similar-columns-2520.1219302/
The 3rd solution is two intermediate queries in Power Query and then a merge query.
Table of Contents
(0:00) How Continue reading “Power Query Split To Rows For 2 Similar Columns – 2520”
Let’s talk about an upcoming change for Power BI Desktop and how it can be deployed. If you use Office 365, it may get a lot easier for you!
David Eldersveld
https://twitter.com/dataveld
Twitter Thread
https://twitter.com/dataveld/status/1576359796449902592
Power BI in Office installer
https://learn.microsoft.com/power-platform-release-plan/2022wave1/power-bi/power-bi-office-installer
📢 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
— <a Continue reading “Office 365 meet Power BI Desktop”
In this tutorial, Sam will show how to implement a security model into your Power BI models with Row Level Security and be able to manage provision users to only see segments of analysis they are allowed to see.
***** Video Details *****
00:00 Introduction
01:11 Regional information
01:55 Creating simple visualisations
02:58 Managing roles
04:08 Viewing as roles
06:15 Publishing and managing security model
***** 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 – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE Continue reading “Scale Your Power BI Reporting With Row Level Security [2022 Update]”