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"
)