Forum Discussion
Format string thousands Value issue
Hello, I work with a tabular model and i create a new measure with the format string as bellow : #,##0,.00 K When create a matrix in power bi and i display the measure i have : 4,456,180.13 K...
Hi Anonymous ,
After using Format, the data type becomes a text type.
https://docs.microsoft.com/en-us/dax/format-function-dax
You can modify dax to the following form:
Measure = FORMAT(MAX('Table'[amount]),"#,##0,K")
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
After using Format, the data type becomes a text type.
https://docs.microsoft.com/en-us/dax/format-function-dax
You can modify dax to the following form:
Measure = FORMAT(MAX('Table'[amount]),"#,##0,K")
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.