Tag: Clean Coding

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

Dimension Table In A Text File: Power Query Solution

Dimension Table In A Text File: Power Query Solution

In this blog post, I’ll go over problem #2 from the ongoing Problem of the Week at the Enterprise DNA forum, where we discussed how to sort messy data into a clean dimension table. This is the second iteration of this new initiative that we’re hosting at Enterprise DNA. I’m especially passionate about this series

Continue reading

Creating A Custom Text Cleaning Function In Power Query

Creating-A-Custom-Text-Cleaning-Function-In-Power-Query

In this blog post, we’ll take a closer look at a custom function for text cleaning that I created for our ongoing series at Enterprise DNA TV called Problem of the Week. You may watch the full video of this tutorial at the bottom of this blog. For week #2, we have a messy data

Continue reading

DAX Formulas Clean Up Tool: Some Updates To Logic

DAX Formulas Clean Up Tool

For today’s post, I want to do a quick overview of our DAX cleanup tool and how you can use it to format your formulas. This epic tool will solve a lot of formatting issues inside of your Power BI models. You may watch the full video of this tutorial at the bottom of this

Continue reading