Missing power query functions

stigcorneer

New Member
Joined
Nov 14, 2018
Messages
24
Hi,
I have a Excelfile with a power query model in it.
It works fine on one computer, but when I run it in on another computer there are errors.

I use excel 2016 on both computers but the one with errors crashed a couple of weeks ago and got office reinstalled just the other day.

The error seem to appear in this function:
Table.TransformColumns(#"Transponerad tabell1", {{"Column1", each Text.AfterDelimiter(_, "Column"), type text}})

When I look at the power query window the function "Text.AfterDelimiter" just isn't there on the second computer.
Is it possible that some of the M functions are missing from the computer and how do I repair it?
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
maybe on the "error" computer try replicate this from the ribbon - extract - Text After Delimiter
if there is an error you should see this on the yellow bar in PQ Editor
 
Last edited:
Upvote 0
I get this error message:
"Expression.Error: The name Text.After Delimiter was not recognised. Check the spelling"
 
Upvote 0

Forum statistics

Threads
1,213,550
Messages
6,114,265
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top