Tag: Table Functions

DAX Table Functions In Power BI

In this blog post, I’ll introduce you to DAX table functions. Table functions are simply DAX functions that return a table. Some of the most common table functions that you can encounter in Power BI are the FILTER, VALUES, and ALL functions. Using these table functions, you can create virtual tables inside Power BI. Physical

Continue reading

Turning Calendar Type Layout Into Tabular Format In Power BI Using Query Editor

Turn Calendar Type Layout Into Tabular Format In Power BI Query Editor Tutorial

Analyzing the data that we have can be difficult if it is not correctly arranged. In this tutorial, I will explain how to transform vertical and horizontal repeated data into a tabular format. We do this so that we can have an easier time analyzing it using Power BI. You may watch the full video

Continue reading

Top Customer Per Product – Power BI Analysis

This tutorial involves finding out your top customer per product using an advanced Power BI analysis. This example perfectly shows how Power BI can generate practical insights once you utilize it effectively. There’s just no other tool out there that’s as versatile and flexible as Power BI. You may watch the full video of this

Continue reading

Optimize Power BI Formulas Using Advanced DAX

I’ll go over some interesting concepts that involve using several table functions to optimize your Power BI formulas. You may watch the full video of this tutorial at the bottom of this blog. I’m going to use an example from the Enterprise DNA Support Forum where one of the members asked if it’s possible to

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. You may watch the full video of this tutorial at the bottom of this blog. Honestly, I haven’t used the GROUPBY function too often, mainly because there are several

Continue reading