Home

Conditional Columns in Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-299509%22%20slang%3D%22en-US%22%3EConditional%20Columns%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299509%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi!%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20a%20problem%20with%20the%20Power%20Query%20version%20for%20excel%202016.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20an%20Office%202016%20Professional%20license%20for%20education%20and%20I%20have%20all%20the%20Updates%20updated%20(according%20to%20Windws10)%20and%20I%20want%20to%20use%20a%20PowerQuery%20in%20a%20data%20file%20that%20I%20have%20imported%20using%20the%20%22Conditional%20column%22%20option%20but%20it%20does%20not%20appear.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EI%20have%20searched%20forums%20and%20can%20not%20find%20the%20reason%20why%20my%20PowerQuery%20does%20not%20have%20it.%3C%2FSPAN%3E%20%3CSPAN%3EI%20have%20read%20that%20it%20is%20a%20problem%20of%20the%20version%20I%20have%20of%20PowerQuery%20but%20I%20do%20not%20know%20how%20to%20update%20it%20so%20that%20this%20option%20appears.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EOn%20other%20computers%20I%20have%20the%20same%20version%20of%20Office%202016%20and%20updated%20and%20the%20option%20%22Conditional%20column%22%20appears%20on%20the%20PowerQuery.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EDoes%20anyone%20know%20that%20Update%20I%20need%20to%20install%20to%20appear%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you%20very%20much%20and%20sorry%20for%20my%20English.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-299509%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EColumn%20conditional%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-774537%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Columns%20in%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-774537%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F252955%22%20target%3D%22_blank%22%3E%40jdacosta%3C%2FA%3E%2C%20I%20have%20similar%20case%20with%20you%2C%20have%20you%20found%20the%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
jdacosta
Visitor

Hi!

I have a problem with the Power Query version for excel 2016.
I have an Office 2016 Professional license for education and I have all the Updates updated (according to Windws10) and I want to use a PowerQuery in a data file that I have imported using the "Conditional column" option but it does not appear.

I have searched forums and can not find the reason why my PowerQuery does not have it. I have read that it is a problem of the version I have of PowerQuery but I do not know how to update it so that this option appears.
On other computers I have the same version of Office 2016 and updated and the option "Conditional column" appears on the PowerQuery.

Does anyone know that Update I need to install to appear?

Thank you very much and sorry for my English.

1 Reply

@jdacosta, I have similar case with you, have you found the solution?