Hi ,

How are you doing?

This week’s video is about a side of DAX that most people don’t explore enough, not changing the calculation itself, but changing how it appears.

I cover 3 really useful tricks.

• One is about dynamic formatting strings, where you can control how a measure appears in a much smarter way.
  
• Another is a neat trick to sort months without creating a month number column.
  
• And the third shows how changing the table inside an iterator can completely change the result you get.

Watch the Video Here





Replace Nested IFs with SWITCH

Nested IFs are fine for simple logic. But once you have multiple conditions, they quickly become hard to read and maintain.

SWITCH gives you a much cleaner way to handle that. I’ve explained this in detail in this video.





A Really Cool Use of Context Transition in DAX

This is a fun example of context transition in DAX.

The measure finds the best selling date inside the current filter context and dynamically returns both the date and the sales value together.

A really good way to understand how filter context changes calculation behaviour in DAX.





This course is for the point where YouTube is no longer enough

You can learn a lot from free videos. But after a point, random tutorials stop being enough, especially in DAX.

Because DAX is not just about writing formulas. It’s about understanding logic, context, and modelling well enough that when a real reporting problem shows up, you know how to think through it and solve it with confidence.

If that’s where you are right now, my DAX & Data Modeling Course will help you go much deeper.

It’s built to take you beyond isolated tricks and help you learn DAX and data modeling in a much more structured way, so you don’t just follow examples, but actually understand the logic and apply it to your own harder data problems.

If that’s the stage you’re at, I think you’ll get a lot out of the course.

Quick question - what challenges are you facing with Al when it comes to Data Analysis? Is it living up to your expectations? Tell me everything...

Hit reply, I am all ears. I might reply to your email if I have further questions.



Planning our July offsite with the full team from both Goodly and Goodly Insights