In a Power BI Paginated Report, you can allow your report consumers to customize what they see in the report such as which columns they want in their table or matrix. Patrick shows you how!
#PowerBI #Paginated #GuyInACube
Category: Power Query
Excel Keeps Inserting A Space In the Name WITHA – 2356
We have a person in our roster with the first name of “Witha”. But Excel constantly changes this to “With A”. We are being stung by one of the thousands of entries in the Excel AutoCorrect Options dialog.
This video will show you how to stop Excel from autocorrecting Witha to With A.
What is a Common Table Expression (CTE) and how do you use them?
We’ve had some questions about what a Common Table Expression (CTE) is. Patrick describes what they are and how you can use them in SQL Server or Azure Synapse Analytics.
WITH common_table_expression (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/queries/with-common-table-expression-transact-sql?view=sql-server-ver16
Sample Scripts – https://github.com/guyinacube/demo-files/tree/master/video%20demos/Synapse
📢 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 “What is a Common Table Expression (CTE) and how do you use them?”
ChatGPT Versus 2 Humans Writing Power Query – 2355
Laura B has a tricky Power Query question today. She needs to delete all rows where B=C and D=E. Bill solves this in the Power Query Editor but knows it is not efficient.
He turns to ChatGPT – an Artificial Intelligence tool that is in a free research preview. Bill is amazed at how quickly ChatGPT writes M code for Power Query. But then he bangs his head against the wall trying to get it to work.
See why Stack Overflow has banned ChatGPT because it generates code that is usually wrong but looks like it could work.
Finally, we turn to Continue reading “ChatGPT Versus 2 Humans Writing Power Query – 2355”
Wait! Using a Power BI Date slicer, what are my dates when using between?
Struggling to get dates when using a between date slicer, or a before, or after? Patrick walks through a straightforward way to get the date values when using a date slicer in Power BI!
📢 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/
— https://guyinacube.com
***Gear***
🛠 Check out my Continue reading “Wait! Using a Power BI Date slicer, what are my dates when using between?”
How to handle Aggregation tables with Averages in Power BI
Using Aggregation Tables in Power BI? Average calculations not working because they aren’t hitting the agg? Patrick explains why this is happening and how you can correct it to get the expected result.
📢 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/
— https://guyinacube.com
***Gear***
🛠 Check out my Tools Continue reading “How to handle Aggregation tables with Averages in Power BI”
To Surrogate Key or Not…
We’ve talked about using a surrogate key in your data warehouse whether that’s Azure Synapse Analytics or something else. Patrick looks at why you should consider this even if you aren’t using a slowly changing dimension.
📢 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/
— https://guyinacube.com
***Gear***
🛠 Check Continue reading “To Surrogate Key or Not…”
🔴 Starting 2023 w/ Marco Russo LIVE (Jan 7, 2023)
Prioritizing questions around DAX Studio 3, optimization, performance, DAX, data modeling, processing, etc…
📢 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
Connect with SQLBI:
Website: https://sqlbi.com
YouTube: https://www.youtube.com/sqlbi
Marco Russo: https://twitter.com/marcorus
Alberto Ferrari: https://twitter.com/FerrariAlberto
📢 Become a member: https://guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training Continue reading “🔴 Starting 2023 w/ Marco Russo LIVE (Jan 7, 2023)”
The Year 2023 is 7 Times 17 Squared – 2354
Happy New Year! I was scrolling through Facebook when Maria O pointed out that 2023 is 7*17^2. That seems interesting. Are there other times in our lifetime that the year is N*NN*^N?
It last happened in 2020. We have a run of them, coming up:
2023: 7*17^2
2025: 9*15^2
2028: 3*26^2
But even cooler is 2025, which is the perfect square of 45^2. Unless you were alive in 1936 or will be alive in 2116, the square year of 2025 will be the only square in our lifetimes.
Excel Extract Peaks From Sine Curves 2353
I have a series of values that goes like a sinus curve. I would like to find each top value in the curve. Is there a function for that?
In today’s video, Bill uses AND, IF and FILTER to find the peaks from the data.
🔴 Power BI tips from the Pros – LIVE (Dec 17, 2022) (Member Chat 2nd Half)
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 (Dec 17, 2022) (Member Chat 2nd Half)”
Build a Slicer Panel in Power BI (2022/2023)
Let’s look at how to build a slicer panel in your Power BI Report! This can help to reduce visuals on the canvas and also make for an app like experience. There are some things to think about though.
For a trip down memory lane, here’s Adam’s 2019 Slicer Panel Video: https://www.youtube.com/watch?v=xy9nmSQeUWg
📢 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
— rel=”nofollow”>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 #GuyInACube