Forum Discussion

Aron_Moore's avatar
Aron_Moore
Icon for Solution Specialist rankSolution Specialist
9 years ago

M Query filter on Value.FromText

So I have a column that I can't change to number but need to filter based on value.   I used the advanced editor to do this and it seems to work in preview, the "values" start where I want, but fai...
Need Help
Aron_Moore's avatar
Aron_Moore
Icon for Solution Specialist rankSolution Specialist
9 years ago

That's the rub, I don't want (can't) have them be numeric. They're used in a hierarchy joining with another table. For the relationship and hierarchy to work, they need to remain text.

MarcelBeug's avatar
MarcelBeug
Icon for Community Champion rankCommunity Champion
9 years ago

Your code is working fine with me and I can load the table without any issues.

 

Can you eloborate on "it fails": don't you get the desired results? Or what error message do you get?