topic Re: comma under comma in table in DAX Commands and Tips

comma under comma in table

fsfs — Thu, 01 Jul 2021 11:49:59 GMT

hey guys

how do I format data so it would appear in the table with commas below each other?

I have

1.05

12.035

-2.4

-20.411

and I would like to get

1.05

12.035

-2.4

-20.411

Re: comma under comma in table

Tanushree_Kapse — Thu, 01 Jul 2021 12:18:37 GMT

Hi fsfs ,

Go to your Power Query Window , then click on Add Custom Column and then put this syntax there

Text.PadStart(Text.From([measure_name]),2,”0″)
It would add zeroes at the start...may be that can get you what you want.

Kudos are always appreciated!

Re: comma under comma in table

fsfs — Thu, 01 Jul 2021 14:53:45 GMT

with zeros I could do this with FORMAT( column, "000.0")

I could do this with several IFs and CONCATENATE (with whitespaces, + signs etc) but I though there might be a FORMAT() option

Re: comma under comma in table

fsfs — Wed, 07 Jul 2021 09:45:20 GMT

Answer - the quickest and most straightforward way to achieve this is to use right alignment, while having data cropped to a certain decimal places 🙂