Tag: Advanced Power BI

How The Query Editor Works In Power BI

For this tutorial, I’ll teach you my best practices while working on the Query Editor. This is an important feature of Power BI which, in my opinion, is under-utilized. Nowadays, they call the query editor the Power Query Editor, which is a much better name than what they initially had called it. Through the query editor, we can retrieve data from multiple

Continue reading

Manage Multiple Date Calculations In Your Fact Table – Advanced Power BI Technique

In this tutorial, I’m going to teach you how to manage multiple date calculations in your Fact Table in Power BI. This is a frequent question in the Enterprise DNA Support Forum. These multiple dates could be order dates, ship dates, expiration dates, and arrival dates, among many others. This information might be located within

Continue reading

Custom Dynamic Segmentation Using DAX In Power BI

In this blog post, I want to go over an advanced DAX pattern about how to create custom dynamic segmentation in Power BI. You can apply this great technique to many scenarios to gain meaningful insights. Dynamic groups are created when a range of different customers are segmented based on different metrics like sales, margin

Continue reading

How To Use Natural Language Query (Q&A) In Power BI

In this tutorial, we’ll go over the Natural Language Query (Q&A) feature in Power BI. There’s so much you can discover just by writing these Google-like queries inside the search bar and dashboards in Power BI. This feature isn’t just for simple queries. It can also be used for very advanced insights that you have

Continue reading

How To Create Budgets With Seasonality Impact Using Power BI

I’m going to show you something specific and quite advanced on budgeting through Power BI. We’re going to dive into how to create budgets with consideration on seasonal impact.  This has great potential mostly because it paves the way for highly effective analysis. It also enables you to automate some of the insights that you

Continue reading