Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Multiple expressions translated into the same value
02-26-2025
06:39 AM
I want to be able to create a column that would look at the column [Scrap Reason] and assign a value based on the expression(s) in the [Scrap Reason] column.
I've tried the SWITCH function
but I get the error
I don't think the VALUE or FORMAT functions are going to help me with this, is there some other way to achieve what I am looking for?
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-26-2025
07:03 AM
@ProcessENG You need SWITCH( TRUE(), ... ) Just add TRUE() as your first parameter and then you should be good.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...

Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
11-28-2023 04:18 PM | |||
10-30-2024 06:55 AM | |||
10-30-2024 05:47 AM | |||
06-20-2024 05:44 AM | |||
03-19-2019 06:20 PM |
Top Solution Authors (Last Month)
User | Count |
---|---|
24 | |
15 | |
9 | |
9 | |
9 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
19 | |
15 | |
14 | |
13 | |
13 |