Performing division on a single column

[JasonF]

Hi All.

Very new to all this and am struggling to work out how I go about changing a column data by dividng it by a fixed number.  I have a set of data from the source that has come in as bytes and I want to change this to GBytes.  I cant change it on the source so haev to do it in BI

any pointers greatfully received.

Thank you

[Greg_Deckler · Accepted solution]

In Power Query (Query Editor), you can use the standard math functions to create a step that divides the column on import. If you do not do it on import, you create a custom column or measure and put in a formula like:

Column = DIVIDE([Column],1000000)

[JasonF]

Hi smoupre

Thanks for the tip.  I found it yesterday as it happens, think I couldt see the wood for the trees.