Big news today for Win / Mac / Online versions of Excel. A new Advanced Formula Editor will make LAMBDA and LET far easier. Among the highlights:
New Advanced Formula Editor (Windows, Mac, Online)
Share Lambda through GitHub
Better Recursion Limits (16x Continue reading “New Excel Formula Editor Debuts – 2466”
Join us live as we answer your questions about Power BI! With special guest, Matthew Roche!
Connect with Matthew:
Twitter: https://twitter.com/SQLAllFather
YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ
Website: https://ssbipolar.com/
💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public Continue reading “REPLAY Power BI tips from the Pros – LIVE w/ Matthew Roche (Feb 5, 2022)”
You wrote some IF functions to assign a score based on numerical ranges. You want to combine those formulas into a single long Excel formula. This video will show you how to do it and how to avoid some pitfalls.
Along Continue reading “How To Combine Multiple IF Formulas In Excel – 2465”
How do you know if a parameter was filtered in your Power BI Paginated Reports? Was a slicer used in the Power BI report that is using the Paginated visual? Adam shows you a way you can find out!
Create and Continue reading “Is a parameter filtered in Power BI Paginated Reports???”
Your co-worker has an Excel formula and when you press Enter, you get “You’ve entered too many arguments for this function.” You can’t even get out of the formula.
Today, I show how the lowly Function Arguments Continue reading “Excel Will Not Let Me Enter This Formula – 2464”
Wyn Hopkins built an Excel-based Wordle game. He saw my video on my Wordle Helper tool and challenged me to solve his game with my Excel file. The results are in.
Wyn’s video challenging me to play:
https://www.youtube.com/watch?v=D4uBZ8gdCTE
Wyn’s Continue reading “Answering Wyn Hopkins Wordle Challenge”
How do you do a date range with the Paginated visual used with Power BI Paginated Reports? Adam shows you how to get a date range going without passing every day’s value within the range.
Create and use the paginated report Continue reading “Create a date range parameter with Power BI Paginated Reports”
Parameters for the Power BI Paginated visual can give you a lot of flexibility. Adam walks you through how to set up the parameters and breaks down what is actually happening with the values.
Create and use the paginated report visual
<a Continue reading “How Parameters work with the Power BI Paginated Visual”
Everyone has their theories on the best starting word for the Wordle game. A lot of people suggest ADIEU. But when you look at the frequency of each letter in the 8000 possible words, a better start word has Continue reading “Wordle Best Starting Words is AROSE not ADIEU – Episode 2463”
I love the Wordle game. One game a day. Three minutes. As I played for the first week, I wondered if Excel could help. It can!
Note that this workbook requires a recent Excel version due to the FILTER formula. You Continue reading “WORDLE Helper In Excel – Solve Wordle Faster! – Episode 2462”
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 Continue reading “REPLAY Power BI tips from the Pros – LIVE (Jan 22, 2022)”
Let’s go into Adam’s mind as he optimizes Power Query to make some Power BI Dataflows run faster to avoid resource usage. The result is INSANE AMAZING!
Power Query M function reference
https://docs.microsoft.com/powerquery-m/power-query-m-function-reference
📢 Become a member: rel=”nofollow”>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/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/
#PowerBI #PowerQuery #GuyInACube