Category: Financial Reporting

Update Your Power BI Dashboard – Power BI Online Service

This is a quick tutorial about how you can make your Power BI dashboard and app more presentable and business-themed. Microsoft recently unveiled a series of updates for Power BI and it’s recommended you utilize these updates to maximize your data management. The dashboard is the key for better data insights, which is why it’s

Continue reading

Creating A Gantt Chart In Power BI Using Matrix

Creating A Gantt Chart In Power BI Using Matrix

In this blog, I’m going to go over some project management insights and specifically talk about creating a Gantt chart in Power BI using matrix in Visual Studio. I’m going to show the logic behind creating this Gantt chart, which is very useful when it comes to project management. A Gantt chart is a very

Continue reading

Effective Ways To Use The GROUPBY Function In Power BI

In this insightful tutorial, I want to feature the GROUPBY function in Power BI. I’ll demonstrate the different ways that you can use this DAX function. Honestly, I haven’t used the GROUPBY function too often, mainly because there are several ways to solve things in Power BI using other table functions. For instance, I’ve used

Continue reading

3 Ways To Combine Values Using DAX Inside Power BI

For this tutorial, I’ll be showing you different ways of how to combine values using advanced DAX functions. This is an amazing DAX formula and I’ll be teaching you three different ways of how to use it. The COMBINEVALUES function is not a difficult DAX function to understand. It’s very simple and is similar to

Continue reading

Data Normalization in Power BI for Different Days Results

Normalizing Results On Different Days - Time Related Analysis In Power BI Using DAX

This tutorial stems from another question on the Enterprise DNA Forum about data normalization. The techniques that I will teach you will be important in getting rid of anomalies that can possibly make things complicated during the data analysis. Occasionally, when running analysis in Power BI, you may need to take into account the sales

Continue reading