Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel 2013 Power Query

Status
Not open for further replies.
pat718

pat718

Programmer
Apr 21, 2014
12
US
I am trying to calculate a minimum value using Power Query. The MIN that can be used in Excel does not work in Power Query. Can some one help me?

Thanks.
 
Sort by date Sort by votes
Hi,

Can you explain exactly what you're trying to do and how you're trying to do it.
 
Upvote 0 Downvote
Hi,

I have different ages of insurance customers. I need to get the minimum age of a group of customers from a specific insurance carrier. I hope that makes sense. There are several insurance carries that contract out to several "companies" in order to decide what insurance premium should a insurance carrier should quote a potential customer.
 
Upvote 0 Downvote
Yes, with Power Query. What formula do I need for getting the minimum value in a column. The MIN that is used in Excel does not work.
 
Upvote 0 Downvote
Please post the SQL that you are using.

What is the data source and what kind of data source is this?
 
Upvote 0 Downvote
I don't have anything to post. I am simply trying to get the formula for deriving the minimum value in Power Query.
 
Upvote 0 Downvote
I don't know. If Table.Min will work to get a minimum value than I guess so. I just don't know how to get the minimum value in Power Query.
 
Upvote 0 Downvote

Getting relevant data from you is like pulling teeth!!!

You NEVER yet revealed the source of your data (access, excel, oracle, db2 etc)
 
Upvote 0 Downvote
SkipVought,

I don't know how to be more clear. I said that I am trying to calculate a minimum value in Excel Power Query. Of course, the data is Excel. I am just trying to get the minimum values of a column of ages. If you need anymore clarification than that then just don't respond. Perhaps someone else can assist me with my SIMPLE request.
 
Upvote 0 Downvote
Why are you using Power Query to calculate an aggregation in, what, this workbook or another workbook?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

renigar
  • Locked
  • Question
Excel Power Query refresh error
Replies
3
Views
1K
SoftwareRT
SoftwareRT
M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
341
combo
combo
Snirt
  • Locked
  • Question
MS-Office 2013 Excel Issue
Replies
1
Views
199
SkipVought
S
lm1340
  • Locked
  • Question
Upload documents to Jira Cloud from SharePoint using Power Automate
Replies
0
Views
274
lm1340
lm1340
renigar
  • Question
Having trouble with Excel Lookup
Replies
5
Views
507
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top