In this video Brian Grant will walk you through just how easy these can be to create a Local ID in Power Query.
In this video Brian Grant will walk you through how you can leverage some more advanced features of the Power Query M language to combining conflicting customer names.
When working with large PBI Datasets, complex calculations, and many different dashboards, speed and efficiency become increasingly important.
Basic aggregations are useful; but decision makers are going to want more and want it quickly. What they’re probably going to need next is time intelligence measures.
Ed shows how to group a list by a field and send an html summary while only using one or two expressions. Perfect for the business user or Power Automate beginner.
Learn how SkyPoint is leveraging databricks and their data lakehouse to connect siloed customer data and create a scalable customer data platform.
In this session, Ajay will demonstrate a practical solution of Dynamic Measures, Dynamic Formatting Using Calculation Groups and Dynamic Page Navigation with RLS in Power BI.
In this video I’m going to show you how to build an automated report which can surface these problems as quick as they show up. In the process you’ll learn about structured values and see the different ways grouping can wrestle down tricky data problems.
In this video I’m going to not only walk you through the surprisingly simple way this problem is solved, I’ll also walk you through how to understand the solution and even use DAX to visualize it on the page.
Group a list by a field and send an html summary while only using one or two expressions. Perfect for the business user or Power Automate beginner.
Using Power Apps, we can customize Modern UI list forms to implement filtered and cascading drop downs.
Rachel Dyer is the Vice President of Analytics at CSG Pro with in-depth expertise of the Microsoft BI stack and dimensional modeling.
Subscribe to CSG Pro. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.
Since 1993, CSG Pro has built modern, scalable software and data solutions. Our data analytics consultants solve problems and ignite victories. We help you understand your data so you can make smarter business decisions. We build custom software applications that strengthen your process and your team.
©1993‐2021 CSG Professional Services, Inc. | Privacy Policy