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
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.
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
