Calculated Column with IF statement not showing correct values

[Anonymous]

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.

[v-lili6-msft]

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

[Stachu]

are there any other non printable characters in the field? e.g. line break etc., you may need to replace those as well

[Anonymous]

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.