Forum Discussion
Error on MIN function while creating custom column
Hi phchu1226
I checked your file, use this code:
= Table.AddColumn(SOP_PROD_OS1, "Custom", each if [S_DATE]=List.Min(SOP_PROD_OS1[#"S_DATE"]) then "Week0" else "Week1")
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos🙏!!
The last step in your file is "SOP_PROD_OS1", you can find it if you open the advance editor.
It shows Navigation because your file is connected to Oracle DB.You can find the Last Date in your list, then find the seven days before the date, and write an if statement to put yes if the date is => than that date.
At the end, filter on Yes on the new column.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos ✌️!!
Hi VahidDM,
Finally it works.. so I should not put step name (#"Navigation") here?
btw, is it possible to filter latest 7 date in query editor?
The last step in your file is "SOP_PROD_OS1", you can find it if you open the advance editor.
It shows Navigation because your file is connected to Oracle DB.
You can find the Last Date in your list, then find the seven days before the date, and write an if statement to put yes if the date is => than that date.
At the end, filter on Yes on the new column.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos ✌️!!