Forum Discussion

Learn2Share's avatar
Learn2Share
Frequent Visitor
3 years ago
Solved

How to replace column values using DAX measure?

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 con...
Need Help
  • DataInsights's avatar
    DataInsights
    3 years ago

    Learn2Share,

     

    Try this measure:

     

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