Forum Discussion

bipro-atlanta's avatar
bipro-atlanta
Frequent Visitor
7 years ago
Solved

Add commas to a text numeric value

My Dax Concatenates values , but their are some blank values however it adds comma in front when i try to concatenate and try to remove   IF(HASONEVALUE('MyTable'[TableID]),(CONCATENATEX( VALUES('...
  • Stachu's avatar
    Stachu
    7 years ago

    would filtering the blanks do the job?

    Measure = 
IF(
    HASONEVALUE('MyTable'[TableID]),
    CONCATENATEX(
        FILTER(VALUES('MyTable'[MissingDateList]),'MyTable'[MissingDateList]<>BLANK()),
        'MyTable'[MissingDateList] ,
        ",",
        'MyTable'[MissingDatelist], 
        ASC
        )
    )
Stachu's avatar
Stachu
Icon for Community Champion rankCommunity Champion
7 years ago

would filtering the blanks do the job?

Measure = 
IF(
    HASONEVALUE('MyTable'[TableID]),
    CONCATENATEX(
        FILTER(VALUES('MyTable'[MissingDateList]),'MyTable'[MissingDateList]<>BLANK()),
        'MyTable'[MissingDateList] ,
        ",",
        'MyTable'[MissingDatelist], 
        ASC
        )
    )