| 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
If there’s ever a community song competition I’m ready !
SUMX time
upbeat happy rap hip-hop summertime song. Listen and make your own with Suno.
Is there a single cell containing lots of different answers?
Any chance of a mocked up screenshot ?
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
