How to... switch values using the SWITCH DAX function


How to SWITCH values in your Power BI DAX

Hey there Reader,

This week we're learning the SWITCH DAX function, which does just what you think it does... it *switches* a value (or text, or whatever) with another value (or text, or whatever).

It's often used like a Nested IF statement, but it's wayyy easier to write and understand.

How to SWITCH values with DAX.

Not loving How To Use Power BI in your inbox anymore? Unsubscribe here.

(because you should only get these emails if you love them and find them useful!)

This Week:

How to SWITCH values with DAX.

Switch huge lists of things, easily.


Recent Posts:

Hide/Show groups of columns in a Table visual

Check out this one after the post below.

How to Hide/Show columns in a Table Visual

Check out this one before the post above.

DAX: MAX

Find the largest.


Check out our How-To Subject collections

Bar Charts

Making, formatting, fixing, even adding benchmark lines to bar charts.

DAX

Making, formatting, fixing, even adding benchmark lines to bar charts.

Hot (& Fresh) Tips!

Making, formatting, fixing, even adding benchmark lines to bar charts.

More from Joe (me)!

You can learn from me in a workshop

I run friendly and informative Beginner and Advanced Power BI workshops. Get started (or level up if you already know the basics) so you can start reporting insights from your data ASAP! Hit the reply button on this email and let's chat.

You can pick my Power BI Brain

After 7+ years of using Power BI daily, I've come across (and sworn at) a LOT of error messages, things that don't make sense, and other challenges. You don't have to go through it all too... you can get me to help you through the challenges. Don't spend hours/days/weeks being frustrated... I've already gone through that FOR you. Talk to me. I can help.

Take care everyone,

Joe.

TraversData.com | LinkedIn | Instagram



Silly Power BI Merch

I also have silly ideas for shirts and stuff.

Sex & Data & Rock & Roll Sticker

(Available on other stuff too)

Subscribe to Joe Travers