0

I'm trying to create a column that only contains the minimum value of another column but keep running into an error. See below: Power Query Window :

enter image description here

Any idea as to what is going on. It seems like the formula should work. Do I have some kind of formatting issue going on?

Thank you

Improve this question
5
  • 3
    In a calculated column, you're only getting that row's value, not the whole column (because the UI changes that into an each function). You'll need to refer to the previous step - e.g. List.Min(#"Changed Type"[Days Until Due]) Commented Aug 28, 2024 at 15:39
  • So the each part needs to be removed? What would the Table.AddColumn function need to look like? I've tried a few different variations and keep getting errors. This was my latest: = Table.AddColumn(#"Changed Type", "Minimum", List.Min(#"Changed Type"[Days Until Due])) Commented Aug 28, 2024 at 16:11
  • Put the each back into that version: Table.AddColumn(#"Changed Type", "Minimum", each List.Min(#"Changed Type"[Days Until Due])) Although you'd probably be better off calculating that as a separate step and then just referring to it. Commented Aug 28, 2024 at 16:39
  • That did it. Thank you! Commented Aug 28, 2024 at 19:13
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. Commented Aug 29, 2024 at 14:05
Related questions
0
Power Query Function Date to Custom Column
0
Power Query excel
1
Power BI Complex Calculated Column
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.