Tag: Custom Column

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

Nested Expressions: Power Query Environments

Nested Expressions: Power Query Environments

In this tutorial, you’ll learn about nested expressions, objects, and environments in Power Query. Nested expressions and variables will be used to discuss how Environments work and help generate data. You’ll also learn to deal with common scenarios when transforming nested objects. Creating Nested Expressions Expressions are defined as a formula used to construct value.

Continue reading

Data Granularity Issues In Power BI

Data Granularity Issues In Power BI

For today’s blog post, I’ll come up with a solution that will address data granularity issues. At Enterprise DNA, we are believers of getting your hands dirty. Our ongoing series, Problem of the Week, is all geared towards putting what you’ve learned into practice. We don’t think there’s a faster way to learn Power BI

Continue reading