Forum Discussion
How to replace column values using DAX measure?
Try this measure:
Output Value = SWITCH ( MAX ( Table1[Existing Field Values] ), 1, "P1", 2, "P2", 3, "P3", BLANK (), "Other" )
Try this measure:
Output Value =
SWITCH (
MAX ( Table1[Existing Field Values] ),
1, "P1",
2, "P2",
3, "P3",
BLANK (), "Other"
)
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!Anonymous,
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").
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!