Forum Discussion
Help convert Excel formula to use in Power Query
Hi Yussufff23 ,
For the MINIFS and MAXIFS functions, please kindly refer to
Power Query Classic COUNTIFS | SUMIFS | AVERAGEIFS | MAXIFS | MINIFS Calculations [Simply Amazing]Or you can use the Group By tool to find the max and min dates, then merge those dates back to the original data. See the Query sheet in the attached file.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yussufff23 ,
The Power Query functions/statements you need are as follows:
IF(X, Y, IF(A, B, C)) = if X then Y else if A then B else C
AND(X, Y) = X and Y
ROUND(X) / INT(X) = Number.Round(X) (use different arguments to adjust output)
AVERAGE(X) = List.Average(X)
MIN(X) = List.Min(X)
MAX(X) = List.Max(X)
LEN(X) = Text.Length(X)
Convert text (X) > Number = Number.From(X)
Convert number (X) > Text = Text.From(X)
Best of luck 👍
Pete
In my formula, I used MINIF and MAXIF functions
Hi Yussufff23 ,
For the MINIFS and MAXIFS functions, please kindly refer to
Power Query Classic COUNTIFS | SUMIFS | AVERAGEIFS | MAXIFS | MINIFS Calculations [Simply Amazing]Or you can use the Group By tool to find the max and min dates, then merge those dates back to the original data. See the Query sheet in the attached file.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
