Tag: group by power bi

Junk Dimension: What Is It And Why It’s Anything But Junk

Today, I want to talk about a data modeling concept called junk dimension. From its name, you’d think it’s a technique that’s derogatory and something you’d want to avoid, but it’s actually a useful approach. In fact, I worked on a question from the Enterprise DNA support forum, and a junk dimension was the perfect

Continue reading

Power Query Function In Power BI: Group By Function

Power Query Function In Power BI: Group By Function

This tutorial is about a power query function in Power BI called Group By. It’s an underrated feature in Power BI that lets you solve common problems in the simplest way possible. You can watch the full video of this tutorial at the bottom of this blog. Group By function is the best option when you have

Continue reading

Organizing Your Queries Into Groups In Power BI

If you have a big data set and a large number of queries, it is a must to do data cleaning. Some users don’t realize how essential data cleanup is inside the Query Editor. You can easily use the options from the Transform ribbon or simply right-click the columns. There’s absolutely no need to use

Continue reading