Can I Add Manual Entry?

[Amit_Jain1]

Is It Possible to Add New Entry (Other than Listed from Select Option) if I am Using SELECT Formula in Valid_If

[Aleksi]

Instead of using SELECT formula in Valid_If, you could use it with the Suggested_Values. Though if you are using Enum or EnumList, you can set the option “Allow other values” as ON.

[Amit_Jain1]

I tried your Suggestion but it is Showing All Entries of That Column
I only want limited Entries that Match
Eg.
SELECT(Sales[Bag Roll Size], ([_THISROW].[Job Name]=[Lisence Ptg.]))

[Aleksi · Accepted solution]

If the option “Auto-complete other values” is ON, it will read your existing values from this column and show them in your dropdown. If you set that option as OFF, it will not show those values.

[Amit_Jain1]

Thanks
it Worked

[Aleksi]

You’re welcome