| Website | https://pbi.guide/ |
| YouTube | https://www.youtube.com/@accessanalytic |
| Details | https://wyn.bio.link/ |
#Excel - it’s here - I love this solution- it’s the easiest multi level, multi row dependent drop down technique I’ve seen
“Includes link to downloadable solution”
Not all solutions are equal.
I saw a single line of code on a forum the other week that solved someone's issue of replacing values using a Table with From & To values.
It seemed B R I L L I A N T ! and so much simpler than List.Accumulate and other methods I've seen.
But... I then tested it on 350,000 rows of data and the refresh was H O R R I D !
So I started digging, and probably got a bit carried away... but here it is...
Me.. doing a deep dive on timing different #PowerQuery solutions
What’s new in October #Excel current channel?
simple demo explaining GROUPYBY / PIVOTBY plus a link at the end to my next video on Python in Excel with Chat GPT
Excel GROUPBY and PIVOTBY plus checkboxes - October 2024 update part 1
https://youtu.be/ks7ZQYvwOVo
A beginners demonstration this week on how to create these 3 things in both #Excel and #PowerBI
- Pivot table v Matrix
- Bar Chart
- Card
The pod has dropped early!
New Episode now out...
1️⃣ What Language / Process would you recommend finance
folks learn and in what order?
2️⃣ What's the most dangerous feature of Excel and Power BI?
How many of these do you use?
TAKE, HSTACK, XLOOKUP, SEQUENCE, UNIQUE, FILTER, VSTACK, SORTBY, ROWS, LAMBDA
Last week Oz du Soleil shared a video of me solving a challenge with Power Query
I wanted to see if I could do it with just formulas - no Power Query!
https://youtu.be/FIcxyLqzWcE?si=GuCgaSXTNIig6Usu
excel
If you're clicking this then there's a good chance you should watch this video. An 18 minute investment of time that may just save hours every month, and lead to your career advancement.
3 Essential Skills for the #Excel Analyst : 1.5 million views
Excellent new feature in the August Update of Power BI desktop
YouTube: https://youtu.be/a6lI_B58wqQ
Much more control over the formatting of values in your visual including the ability to apply formatting to Visual Level Calculations!
Excel v Power BI & what would you change if you could
Thank you to Cristian Angyal for joining us.
Question of the day: If you could change 1 thing in Excel and Power BI what would it be?
Plus when should you use Excel v Power BI, and a side journey into SQL
https://unpivot.podbean.com/
Spotify & Apple
Just 4 lines of M code solves last week's challenge.
Generally I find it easier to remember and explain the User Interface clicks approach but once you start to see the power of lists and remember the syntax it unlocks other paths.
