Forum Discussion
Calculate a date based on text value
Hi everyone. New to power query here. Wondering if you can help me with this. I have a table containing some data regarding tasks, and would like to calculate a date based on the urgency rating. ...
Sorry, I guess I'm just a little confused -- as I already have quite a few different columns in my table. I'm also sourcing the data from Sharepoint so my advanced query editor is a little harder to edit.
Is there another way that this can be achieved without adding / editing the query?
Why would you expect the outcome of a query to change if you don't change the query? Whether you accomplish this in the Advanced Editor, or in the Power Query User Interface is irrelevant.
When you followed the suggestion put forth by ppm1 and clicked on the #"Added Custom" step, what did you see? That is the formula to use if you are changing the query using the UI.