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

Can you make a two-line dynamic title in Power BI?

Dynamic titles in Power BI can be really useful. What about a multi-line title? Patrick is answering a commenter's question on how to create a two-line dynamic title! Dynamic Titles in Power BI Desktop https://www.youtube.com/watch?v=TYLKDPcvgK8

Can you make a two-line dynamic title in Power BI?2022-12-07T07:41:47-05:00

Writing some DAX while looking at Relationships

Every struggle with writing DAX and having to flip between the report view and the model view in Power BI Desktop? The struggle was real! Patrick shows you a new update that overcomes this!

Writing some DAX while looking at Relationships2022-11-13T18:38:22-05:00

🔴 Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)

Prioritizing questions around 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, [...]

🔴 Power BI Optimization Q&A – LIVE w/ Marco Russo (Aug 5, 2022)2022-08-21T14:49:07-05:00

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion! DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/ Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???2022-05-11T06:40:26-05:00

How to get a DATE TABLE easily in Power BI

Do you use a central date table for your Power BI datasets? There is a LOT of POWER in having one. Adam shows you different ways to create one including a really simple easy option that's BANANAS! REDUCE Power BI dataset size by 60% with ONE CHECKBOX??? https://www.youtube.com/watch?v=RnDdDlozcdo Bravo for Power BI https://bravo.bi

How to get a DATE TABLE easily in Power BI2022-04-14T07:04:44-05:00

Flexibility with Days Since calculations in Power BI

Calculating Days since a given date in DAX is pretty straight forward. But, what if you want flexibility with different dates in your model? Patrick shows you how to do that with Power BI.

Flexibility with Days Since calculations in Power BI2021-11-10T08:49:30-05:00

What’s this Power BI report filtered by???

Struggling with understanding what is filtering your visual or Power BI report? Patrick walks you through how you can tell what is going on. SQLBI Filter Context: https://www.sqlbi.com/articles/displaying-filter-context-in-power-bi-tooltips/

What’s this Power BI report filtered by???2021-10-27T06:23:25-05:00

When optimizing Power BI don’t forgot about CPU

We talk about optimizations a LOT! We pile onto a question posed by Chris Webb - Should you optimize for CPU in Power BI? We think the answer is YES! Let's explain... Chris Webb's Blog: https://blog.crossjoin.co.uk/2021/09/19/why-you-should-optimise-your-power-bi-premium-reports-and-refreshes-for-cpu-time-as-well-as-duration/ 3 signs it's time to OPTIMIZE your Power BI report https://www.youtube.com/watch?v=uKSkMDEGM2I

When optimizing Power BI don’t forgot about CPU2021-10-14T07:48:47-05:00
Go to Top