Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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."
Solved! Go to Solution.
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
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.
User | Count |
---|---|
37 | |
12 | |
4 | |
3 | |
2 |
User | Count |
---|---|
46 | |
19 | |
7 | |
7 | |
6 |