Tag: Pivot Query Editor

Proportion And Frequency Tables In Excel

FREQUENCY & PROPORTION TABLES IN EXCEL

In this tutorial, we’re going to dive into frequency tables in Excel as well as proportion tables. We’ll look into what they are and when to use them. You can watch the full video of this tutorial at the bottom of this blog. Categorical variables measure “what kind of something,” whether it’s a customer’s buying

Continue reading

Power BI Modulo and Integer-Divide DAX Functions

I thought it’d be interesting to find a way to highlight functions and operators in Power BI that you may haven’t come across before, deeply buried in the menus, or those that you may have seen, but don’t really know what they do. For this tutorial, I’d like to highlight the Power BI Modulo and

Continue reading

Unpivot And Pivot Basics In Power BI – Query Editor Review

There are many occasions where you may bring data into Power BI and the data structure is not optimized for your data model. In this article, I’m going to work through when you should utilize the unpivot or pivot feature in the Query Editor within your data queries. One thing to bear in mind early

Continue reading