DAX to Replace Values

[Julaiha]

Hai Expert,

I need to creata a dax that will shows dash (-) when user choose year slicer 2023 onwards , this dash is to replace value null/blank for the year 2023 onwards.

[rubayatyasmin]

Hi, @Julaiha 

Here is the sample DAX based on your requirement. 

Measure = 
CALCULATE(
    MAX('YourTable'[OriginalColumn]),
    FILTER(
        'YourTable',
        'YourTable'[Year] < 2023
    )
) & IF(MAX('YourTable'[Year]) >= 2023, "-", "")

[ChiragGarg2512]

@Julaiha Is this required in a slicer or what? Share an image on what the requirement is.