In this blog post, we provide a step-by-step guide on how to use the Group By function in Power Query to reduce the number of rows in your data tables. Whether you are working in Power BI or Excel, this post will show you how to aggregate your data by a grouping variable to build a leaner and faster data model.
In this blog post, we provide a step-by-step guide on how you can connect to a local folder in the Power BI Desktop app.
In this post we break down the ins and outs of a centralized versus a distributed Power BI implementation strategies and introduce “hybrid Power BI” as a potential candidate. Learn the good, the bad and what type of organization each strategy is best suited for.
In this blog post, we provide a practical guide to creating rolling average (i.e., last 30 days) measures in Power BI using the built-in DAX (Data Analysis Expressions) programming language.
In this post, we show you how to create a dedicated Measures Table to keep your calculations organized, your data model clean, and your workflow efficient. Whether you're working solo or collaborating with a team, this simple trick will save you time, and future-you will thank you.