maximum and minimum value in decimal numbers a rows - query editor

[skopcak]

Hello,

Can you please advise how the query editor power to do this? Thank you

Item No.	01/01. Item Price	10/01. Item Price	20/01. Item Price	30/01. Item Price	05/02. Item Price	25/02. Item Price	05/03. Item Price	08/04. Item Price	09/05. Item Price	result maximum	result minimum
123456789	5,24	6,84	6,25	8,45	7,43	5,89	7,59	8,95	9,52	9,52	5,24
98765432	5,24	3,84	6,25	10,45	7,43	5,89	7,59	8,95	9,52	10,45	3,84

[v-qiuyu-msft]

Hi @skopcak,

The Statistics feature can also work when you check more than one decimal number columns in Query Editor. Please check how many columns you selected, and verify the data type are Decimal Numbers.

 

Best Regards,
Qiuyun Yu

[Vvelarde]

@skopcak

Select All your columns except Item No.

Go to Add Column--Statistics - And Select Maximum or Minimum

[skopcak]

OK, thank you, please give it about getting on decimal numbers? Integers me it goes, but when, I will set decimals, so this box is not active.

[Vvelarde]

@skopcak

you should'nt have problems with decimals in this operation.

Before check the type of your columns. Are there recognize like numbers?