Forum

Hi Peter, Yes this situation can be dealt with. The code creates a list of values that can be converted to a number. If the value is text and can...

Hi Peter, See file attached for solution. The general approach with this is to split the text into sections using Text.Split. This gives you a Li...

Hi Jacek, I don't really understand what you are trying to do. Can you try to explain it again with some real tables and columns? Regards ...

Hi Alan, It's possible to deal with changing column names - but really the best solution is to fix the problem at source. Can you get the new file...

Hi, Please start your own topic, not tag on to the end of a question that's already answered. You need to provide the full path to the executa...

Hi Zak, I'd suggest before anyone attempts this that you standardise your data structure. You say 'identical named ranges' but then say areas wi...

Hi John, See attached file - This code merges pairs of columns as you describe : 3+4, 5+6 etc and will work for any number of columns providing it'...

Hi Irina, Without seeing your whole query it's hard to say what might be the issue. Need to know the types of transformations you are doing. Tab...

Hi Krishna, You're running this from my query to NASA from this blog post? I don't know why you'd get that error. The Excel file still works...

Hi Danielle, Correct. Power Query shows you the data as it actually is, without leading zeroes. In Excel or DAX you can apply formatting to affect...

Hi Danielle, That's a formatting/display problem that you would do either directly in excel or in DAX, not in Power Query. Your attached Excel f...

You're welcome, glad to help. Phil