Forum Discussion
Solved
LARGE IF Functions Within A Table
Hello!
I am combining the LARGE & IF functions within a column of a table. I want the formula to look for matching parameters within the same table and then give me the largest # for each row in the table, however it's just not working. Here is the formula I'm using:
{=LARGE(IF( [7]=[1], [36]),1)}
A couple of other notes:
- All of the examples of this function I have seen show it OUTSIDE of the table, not WITHIN the table. This makes me wonder if it's even possible to accomplish this with the LARGE/IF functions within a table or if maybe there's another way to do it(?)
- I have tried it both as an array and non-array formula, but without success.
That could be
... pParText = fParameter(ParameterTable,From), Source = Sql.Database(Server, Database, [Query = "CALL SALES_BY_CATEGORY_1234 ( '51', " & pParText & " '2020-12-31','',......)"]), nextStep, ...Another way is as here Chris Webb's BI Blog: Passing Parameters To SQL Queries With Value.NativeQuery() In Power Query And Power BI Chris Webb's BI Blog (crossjoin.co.uk) but in general they are not too far from each other.
