Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
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
Select All your columns except Item No.
Go to Add Column--Statistics - And Select Maximum or Minimum
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.
you should'nt have problems with decimals in this operation.
Before check the type of your columns. Are there recognize like numbers?
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |