Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
HamidBee
Power Participant
Power Participant

Type mismatch Expression type could not be evaluated. Correct the expression

I am completely new to Dataflows. This is my very first attempt at creating one. Here is a snapshot of the data I am working with:

 

Region Name Location ID Client Lot ID Stall Location Name Vehicle Type Vehicle ID License Plate Member ID Date Start Transaction ID Parking Segment ID New or Extended Parking Session Payment Amount Total Date Expire Parking Amount Total Paid Duration Eligibility Type
Springfield 10007 10007   652 8th Avenue Car 32398094 GW22DQZ 22975507 2/1/2023 16:54 8.52E+08 3.73E+08 Is_Not_Extension 73.08 2/4/2023 18:46 73.08 80 CUSTOM
Springfield 10019 10019   Sycamore Avenue Car 93477580 ZE26IIN 76168871 11/14/2023 1:21 3.77E+08 5.36E+08 Is_Not_Extension 69.97 11/15/2023 13:13 69.97 185 CUSTOM
Springfield 10003 10003   181st Street Car 37155431 BG61HXC 12859951 5/30/2023 2:20 8.36E+08 8.79E+08 Is_Not_Extension 38.33 6/6/2023 19:20 38.33 188 CUSTOM

 

The first thing I did was remove the Stall column. Then I changed the datatype from string to integer (I think it's correct):

 

 

 

toInteger({Payment Amount Total})

 

 

 

Then I tried to multiply the 'Payment Amount Total' column by 2 using this expression:

 

 

 

[Payment Amount Total] * 2

 

 

but it's giving me an error:

 

"Type mismatch
Expression type could not be evaluated. Correct the expression."

 

1 ACCEPTED SOLUTION
GeethaT-MSFT
Community Support
Community Support

Hi, @HamidBee Thanks for posting your question in Microsoft Fabric Community

you have already converted the 'Payment Amount Total' column to an integer using the 'toInteger' function. However, the square brackets around the column name indicate that you are trying to access the column as a string

can you remove the square brackets and use the curly brackets and try?

 

Regards

Geetha

View solution in original post

2 REPLIES 2
GeethaT-MSFT
Community Support
Community Support

Hi, @HamidBee Thanks for posting your question in Microsoft Fabric Community

you have already converted the 'Payment Amount Total' column to an integer using the 'toInteger' function. However, the square brackets around the column name indicate that you are trying to access the column as a string

can you remove the square brackets and use the curly brackets and try?

 

Regards

Geetha

Thanks, this resolved the issue.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!

JanFabricDF_carousel

Fabric Monthly Update - January 2025

Take your data replication to the next level with Fabric's latest updates!