Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Convert values into whole numbers and decimal based on case

Hi,   I have a two columns within the dataset. One is Attribute and second value   Attribute  Value Volume   0 Volume   5 Speed     0.05 Speed     2.93   Above is how the data is coming. B...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Create a column using below dax expression:

     

    Column = IF('Table'[Attribute] ="Volume",FORMAT('Table'[  Value],"general number"),IF('Table'[Attribute] ="Speed",FORMAT('Table'[  Value],"fixed"),BLANK()))

     

     And you will see:

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Create a column using below dax expression:

 

Column = IF('Table'[Attribute] ="Volume",FORMAT('Table'[  Value],"general number"),IF('Table'[Attribute] ="Speed",FORMAT('Table'[  Value],"fixed"),BLANK()))

 

 And you will see:

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!