How to replace column values using DAX measure?

[Learn2Share]

Hi,

Is it possible to change column values using dax measure (no option to modify power query/tranform data option, no option to create a calculated column as Powerbi is connected to AAS live connection)

Such that if I pull an attribute "Sno" on table visual &  this measure I should get output as below?

Sno	Existing Field Values	Measure Output Values
1	1	P1
2	2	P2
3	3	P3
4	BLANK	Other

[Learn2Share]

thank you @DataInsights , this works!

[DataInsights · Accepted solution]

@Learn2Share,

Try this measure:

Output Value = 
SWITCH (
    MAX ( Table1[Existing Field Values] ),
    1, "P1",
    2, "P2",
    3, "P3",
    BLANK (), "Other"
)

[JimBoyce]

I have a related question. I'm currently using a column name called ItemName in tables and charts, but would instead like to use a measure value ShortName:

I would like to replace the ItemName value with ShortName:

ItemName	ShortName
Product Group Alpha	Alpha
Product Group Beta	Beta
Product Group Charlie	Charlie

Here's what I tried:

ShortName =

    SWITCH(

        MAX('DimCatalogItemServiceSDD'[ItemName]),

        "Product Group Alpha", "Alpha",

        "Product Group Beta", "Beta",

        "Product Group Charlie", "Charlie",

        "Nada"

    )

When I add the measure to a blank table visual, all I get is "Nada".

Any help would be appreciated!

[DataInsights]

@JimBoyce,

The simplest approach is to create a custom column (Power Query) or calculated column (DAX). If neither of these are options, temporarily change your measure to return the first SWITCH argument:

MAX('DimCatalogItemServiceSDD'[ItemName])

It appears there is a value in ItemName that is not in your SWITCH expression (causing it to return "Nada").

[JimBoyce]

I appreciate the response. I get what you're saying, but I'm not sure how to modify the measure to return the first result. Can you provide what the full measure would look like based on the above example? Thanks!

[DataInsights]

@JimBoyce,

Something like this:

Test Measure = MAX ( 'DimCatalogItemServiceSDD'[ItemName] )

You mentioned that you added your measure to a blank table visual. That means there's no filter context (other than external filters) so the max value of ItemName in the entire column (considering external filters) is what gets returned. It's better to create a lookup table than to use DAX.