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

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

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

A Power Query tip for you

You probably know that you can concatenate strings in Power Query. Not big news there. But do you know how to change the order of how things are concatenated? Patrick shows you how!

A Power Query tip for you2022-12-14T07:15:12-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

Make Q&A more effective in Power BI

Most struggle with getting Q&A to be effective in Power BI. Usually this comes down to either model naming or synonyms. Patrick shows you how you can update these and also a nice feature to let you share them with others.

Make Q&A more effective in Power BI2022-10-26T07:04:36-05:00

Office 365 meet Power BI Desktop

Let's talk about an upcoming change for Power BI Desktop and how it can be deployed. If you use Office 365, it may get a lot easier for you! David Eldersveld https://twitter.com/dataveld Twitter Thread https://twitter.com/dataveld/status/1576359796449902592 Power BI in Office installer https://learn.microsoft.com/power-platform-release-plan/2022wave1/power-bi/power-bi-office-installer

Office 365 meet Power BI Desktop2022-10-10T04:14:11-05:00

Let Power Query write your SQL for you!

We tell you to push your transformations upstream as much as possible. But you don't know how to write SQL. That's ok, let Power Query do it for you to move your project forward. Patrick shows you how!

Let Power Query write your SQL for you!2022-10-10T03:54:23-05:00
Go to Top