I am attempting to learn M and I am having trouble with a simple if statement.
The objective is to read the last letter of each file name and produce a certain result based on that. The Formula and data range is as follows:
CaptureHelp.PNG
Formula - if Text.End([Name.1]) = "A" then "Actual" else if Text.End([Name.1]) = "B" then "Budget" else "Forecast"
For some reason I am getting the following error:
Expression.Error: 1 arguments were passed to a function which expects 2.
Details:
Pattern=
Arguments=List
Any and all help is greatly appreciated. Thanks in advance.
Bookmarks