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.
Hi,
I just run into a problem. I need to create a calculated column, that looks at the value in column Currency and returns a correct exchange rate measure. Basically the funtion looks like following:
Column1 =
IF(Table[Currency] = "USD"; [CurrentEURUSD] ; 1)
Problem is that sometimes when the Currency column has a value USD, the calculated column shows the right value (value of the measure) but sometimes it just returns blank. Any idea what may cause this? I tried to use the trim function in the Query editor to ensure there are no additional spaces but it didn't help.
Hi@ kosti_h
After my research, cause of returning blank is not format of the column Currency, It should be something wrong in the related column of the measure [CurrentEURUSD].
For example:
My measure is: Measure = SUM(Table1[Rate])
And the result
But when I add the data in column Rate of first row, the blank will disappear.
Please check the data and the measure or you can share your pbix for us. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
are there any other non printable characters in the field? e.g. line break etc., you may need to replace those as well
I actually figured out that this had something to do with my table relationships with the DateTable. When there was no connection active, the function worked out just fine. I have to investigate more on this.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |