Power Query where to put Number Round

[dicken]

Hi
I've been trying to use Number.Round and can't seem to put it in the right place,

the column being rounded is as follows;

 Table.AddColumn(#"Added Custom3", "Custom", each Text.Combine( 
List.Transform( 
List.Distinct( [Count] [stdev] ),(_)=> Text.From(_) ),", "))

I know I can just change the data type to decimal number but it's annoing me.
Richard

 

[johnny51981]

Since you are creating the column based on calling for Text, you'll first want to change it to a Number (I know...we're still in M Code here). And then you should be able to include your Number Round.

So Give this a shot:
Number.Round(
Number.FromText(
Text.Combine(
List.Transform(
List.Distinct( [Count] [stdev] ),(_)=> Text.From(_) ),", "))),[Number of Decimal Places])

 

[dicken]

Since you are creating the column based on calling for Text, you'll first want to change it to a Number (I know...we're still in M Code here). And then you should be able to include your Number Round.

So Give this a shot:
Number.Round(
Number.FromText(
Text.Combine(
List.Transform(
List.Distinct( [Count] [stdev] ),(_)=> Text.From(_) ),", "))),[Number of Decimal Places])

Hi,
Sorry for not getting back to you sooner, worked but not how I expected, as soon as I used Number form text or eve just Number.From,
it became rounded to 2 places and jumped to the 'right ' side, so using Number.Round wasn'te needed unless you want less then two decimal places, I love (?) the fact that I had to convert to text to use Text.combine and then back to a number to round ho hum.

Will mark up as solved.

Richard.