topic Re: Number format in DAX Commands and Tips

Number format

Sujit_Thakur — Wed, 16 Sep 2020 07:39:18 GMT

Dear all ,

I have a measure which returns me value such as

1000

3200

500000

I want to return

3.2k

500k

I tried using format into thousand but it converts all numbers to K format

I want only those numbers to turn in K format which are greater than 1000

Need help

Regards

Sujit

Sujit_Thakur — Wed, 16 Sep 2020 07:44:43 GMT

Ok friends

I tried and I reached to conclusion

Loss = var a = MEASURE

RETURN IF(a>=1000,Format(a,"#,.#K"),a)

If you have more optimized solution please feel free to shoot your advices in comments down 👍

amitchandak — Wed, 16 Sep 2020 07:44:51 GMT

Sujit_Thakur , In model view , you have property. Once you click on a column then you will be able set its property there you can set format -https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings

or you can use the format command. Or can mention format in measure/column tools

The above article also contain how to give format string

amitchandak — Wed, 16 Sep 2020 07:46:17 GMT

Sujit_Thakur , Thanks for sharing.

Sujit_Thakur — Wed, 16 Sep 2020 08:40:13 GMT

No problem sir 🙏😀