Forum

How to find the Hig...
 
Notifications
Clear all

How to find the Highest and Lowest values in data using a power query?

4 Posts
2 Users
0 Reactions
74 Views
(@mazharul)
Posts: 5
Active Member
Topic starter
 

Hi,

I face a new problem. How to find the highest and lowest values in my data according to date using a power query? 

Thank you.

Regards,

Mazharul

 
Posted : 05/05/2021 10:25 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Mazharul,

Please supply a file with some sample data and an example of the results you are looking for.

Regards

Phil

 
Posted : 05/05/2021 11:40 pm
(@mazharul)
Posts: 5
Active Member
Topic starter
 

Hi Phil,

Here I have attached a sample file and result format. I need to sort highest and lowest value using power query and when my data will updates my result will also updates according to data, thats my desire results. Please help me.

Thank you.

Regards,

Mazharul

 
Posted : 09/05/2021 2:44 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Mazharul,

That CSV contains no data, just column names.

Regards

Phil

 
Posted : 26/05/2021 12:04 am
Share: