Forum Discussion

Cindy16's avatar
Cindy16
Regular Visitor
2 years ago
Solved

Measure tool's format setting and format function in DAX return different result

Hi Team,  I can not format the value correctly through the "format" DAX expression. Below is the data source I created as a sample. The final result needs to show with K and no decimal. I...
  • nareshr89's avatar
    nareshr89
    2 years ago

    Try this DAX

     

    ValuesF =
    var Kvalue = SUM(Sheet1[Tried Value])/1000
    RETURN
    IF(Kvalue>=0,FORMAT(Kvalue,"+#,0"),FORMAT(Kvalue*-1,"-#,0"))
nareshr89's avatar
nareshr89
Helper II
2 years ago

Try this DAX

 

ValuesF =
var Kvalue = SUM(Sheet1[Tried Value])/1000
RETURN
IF(Kvalue>=0,FORMAT(Kvalue,"+#,0"),FORMAT(Kvalue*-1,"-#,0"))