Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a Table named "Rebates Paid" and the table has a Column that holds the Rebates Paid Amount but that value can be either USD or CAD depending on the row. I have another column, called [Currency] which holds the currency type(either USD or CAD).
I've created a Measure named[_CAD] to store the exchange rate I want applied to the CAD rows only.
I'm trying to add a simple IF Statement to a Calc Column so that I can convert any rows that have CAD currency to USD, otherwise I want to use the value found in the Rebate Paid Amount. If statement is as follows:
Solved! Go to Solution.
Typically, you get this sort of error when your if returns text for one result and a number for the other. This situation doesn't look like it has text output though.
What are the data types for the [Total Rebates Paid] column and [_CAD]?
Based on the error message, it is caused by the different data types in column.
Check the 'Rebates Paid'[Currency] and 'Rebates Paid'[Total Rebates Paid] data types.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
New Year Power BI eCard:
https://community.powerbi.com/t5/Data-Stories-Gallery/Happy-New-Year/td-p/2266398
Hello Alexis, the data type for Total Rebates Paid and CAD are both numeric which is why I don't understand the error message.
Based on the error message, it is caused by the different data types in column.
Check the 'Rebates Paid'[Currency] and 'Rebates Paid'[Total Rebates Paid] data types.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
New Year Power BI eCard:
https://community.powerbi.com/t5/Data-Stories-Gallery/Happy-New-Year/td-p/2266398
Thank you! This worked. One of the columns had a AlphaNumeric data type. Once I switched it over to Numeric the issue resolved. Happy New Year!
Typically, you get this sort of error when your if returns text for one result and a number for the other. This situation doesn't look like it has text output though.
What are the data types for the [Total Rebates Paid] column and [_CAD]?
Hello Alexis, the data type for Total Rebates Paid and CAD are both numeric which is why I don't understand the error message.
Actually, I just did a double check and the Rebates Paid did have a AlphaNumeric data type. I've switched it over to numeric and it resolved the issue. thank you so much! Happy New Year!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
57 | |
50 | |
44 | |
21 | |
19 |