Forum Discussion
New Column not showing in Transform data
Hi I have added a new column being a LOOKUPVALUE (as data comes from a different table)
I now want to use this new column to apply a Conditional Column in Transform data however this new column is not showing in this area?
This is the new column which has worked, but I just can't seem to use this?
Thanks in advance
Kelly
3 Replies
Kelly-DS ,
You won't be able to see the calculated table/columns in Query Editor.
Appreciate your kudos!! Please mark my post as solution if this helps.
- amitchandak
Super User
Kelly-DS , You have to create that column in Power Query.
Refer if these can help in that
https://eriksvensen.wordpress.com/2019/02/28/powerquery-replicate-doing-an-excel-vlookup-in-m/
https://www.myonlinetraininghub.com/excel-power-query-vlookup
Then you can use it in data tranformation
Please provide your feedback comments and advice for new videos
Tutorial Series Dax Vs SQL Direct Query PBI Tips
Appreciate your Kudos. - Icey
Community Support
Hi Kelly-DS ,
Why do you want to create a conditional column in Power Query? Can it be created using DAX?
Please share us some sample data and your requirements. Maybe we can provide some help.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
