Forum Discussion

Julaiha's avatar
Julaiha
Frequent Visitor
2 years ago

DAX to Replace Values

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.
Need Help
Show and Tell
Tips and Tricks
rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
2 years ago

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