Tag: Problem of the Week

Time Tables In Power BI: Solution For POTW #10

Time Tables In Power BI- Solution For POTW #10

On this blog post, I’ll be bringing you the solution for working with time tables in Power BI, which is our Problem of the Week #10. This wasn’t an overly difficult challenge. But still, it was quite a niggly one that threw in quite a few curve balls. You can watch the full video of

Continue reading

DAX Calculation Groups – Power BI Report for Problem Of The Week #7

DAX Calculation Groups – Power BI Report for Problem Of The Week #7

I’m going to talk about the solution I came up with for the 7th Problem of the Week. The problem required a dynamic report that uses multiple DAX calculation groups. You can watch the full video of this tutorial at the bottom of this blog. The Problem of the Week happens every 1st and 3rd

Continue reading

Time Period Analysis – Intro To Problem Of The Week #10

WORKING W TIME TABLES DAX PROBLEM

In today’s blog, we’ll discuss Problem of the Week #10. The problem of the Week is an ongoing series where we solve real-world scenarios through DAX and Power Query. This week, we’ll deal with a time period analysis. You may watch the full video of this tutorial at the bottom of this blog. The problem

Continue reading

Enterprise DNA April Updates: New Course, Showcases and More

One thing that we love about the Enterprise DNA community is the fact that everyone has this unending thirst for knowledge. That’s why we’ve made it our mission to keep finding new ways to help everyone collaborate, educate and learn. The amazing things we did here at Enterprise DNA in April is clear proof of

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 some messy data

Continue reading