Add Suffix depending on Condition

[Skybluekid]

Hi

Is there a way to add a suffix depending on the number of characters in a column. in other words, I have a column that shows the size of the file. What I would like to do is show the size in K or M depending on the size. So if the file size is over 1MB, then it would show the file size as xx.xx M. If it is under then it will show it as a K value

Thanks in advance

 

[EFANYoutube]

How do I format cells to show GB, MB, KB

I found this for you, should help you fix your issue

 

[Skybluekid]

Thank you, but this is in Excel, I would like it to be a Column generated in Power Query.

 

[RoryA]

You can use something like:

=if [V]>1048576 then Number.ToText([V] / 1048576, "F2") & "MB" else Number.ToText([V] / 1024, "F2") & "KB"

where V is the name of your field (assumes it's in bytes)

 

[Skybluekid]

Thank you Rory A, Works a Treat