fbpx

Time to look at the new INDEX function in DAX and Power BI

The latest DAX functions in Power BI can be very "power"ful! Patrick starts by looking at the INDEX function to solve a customer problem! Blog announcement: https://powerbi.microsoft.com/blog/power-bi-december-2022-feature-summary/#post-21693-_Toc121395731 INDEX function (DAX) https://learn.microsoft.com/dax/index-function-dax WINDOW function (DAX) https://learn.microsoft.com/dax/window-function-dax Chris Webb's Blog https://blog.crossjoin.co.uk/2023/01/02/why-dax-window-functions-are-important-for-performance-in-power-bi-directquery-mode/ Jeffrey Wang's Blogs on Window Function https://pbidax.wordpress.com/2022/12/15/introducing-dax-window-functions-part-1/ https://pbidax.wordpress.com/2022/12/23/introducing-dax-window-functions-part-2/

Time to look at the new INDEX function in DAX and Power BI2023-02-08T09:15:44-05:00

🔴 Power BI tips from the Pros – LIVE (Feb 4, 2023) (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 👉 [...]

🔴 Power BI tips from the Pros – LIVE (Feb 4, 2023) (Member Chat 2nd Half)2023-02-03T07:41:33-05:00

🔴 Power BI tips from the Pros – LIVE (Jan 28, 2023) (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 👉 [...]

🔴 Power BI tips from the Pros – LIVE (Jan 28, 2023) (Member Chat 2nd Half)2023-01-27T09:44:00-05:00

🔴 Power BI tips from the Pros – LIVE (Jan 21, 2023) (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 👉 [...]

🔴 Power BI tips from the Pros – LIVE (Jan 21, 2023) (Member Chat 2nd Half)2023-01-20T06:57:04-05:00

Allow users to Show and Hide columns in a Power BI Paginated report!

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! Sample RDLs: https://github.com/guyinacube/demo-files/blob/master/video%20demos/RDL/20230118%20-%20Paginated%20Show%20Hide%20Columns.zip

Allow users to Show and Hide columns in a Power BI Paginated report!2023-01-18T07:26:47-05:00

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.

How to handle Aggregation tables with Averages in Power BI2023-01-04T07:15:36-05:00

🔴 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 👉 [...]

🔴 Power BI tips from the Pros – LIVE (Dec 17, 2022) (Member Chat 2nd Half)2022-12-16T06:19:15-05:00

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

Build a Slicer Panel in Power BI (2022/2023)2022-12-15T07:57:26-05:00
Go to Top