Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I'm currently facing an error which states
"Expression.Error: We cannot apply field access to the type Function.
Details: Value=[Function] Key=P_Beneficiary_Name".
I'm using the below in custom column, when I write the below code I see no error, but when I save this and check in my table the column shows error and the error message is the above line that I've shared. Please
if ( Text.StartsWith [P_Beneficiary_Name] = "CLIX CAPITAL" and Text.Contains [Program_Type] = "Pre Approved" ) then ([Gross_LOAN_AMOUNT] - [P_Amount_Disbursed] ) else [Gross_LOAN_AMOUNT]
Thanks,
Ankit
Solved! Go to Solution.
It should be
if ( Text.StartsWith( [P_Beneficiary_Name] , "CLIX CAPITAL") and Text.Contains( [Program_Type] , "Pre Approved" )) then ([Gross_LOAN_AMOUNT] - [P_Amount_Disbursed] ) else [Gross_LOAN_AMOUNT])
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
It should be
if ( Text.StartsWith( [P_Beneficiary_Name] , "CLIX CAPITAL") and Text.Contains( [Program_Type] , "Pre Approved" )) then ([Gross_LOAN_AMOUNT] - [P_Amount_Disbursed] ) else [Gross_LOAN_AMOUNT])
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!