Condition Statement

Hello @karabryan ,

Could you please try to use firstnonblank in your formula like:

LOOKUPVALUE(
    FIRSTNONBLANK(Currency[NewRate],1),
    Currency[NewSourceTarget],
    Booking[NewSourceTarget]
    Currency[Date],
    Booking[Date]
)

If this post helps, then consider Accept it as the solution to help other members find it faster.

Best regards

Dedmon Dai

Hi karabryan ,

In order to have a more permanent solution believe you need to do the following:

• Create a measure with the following code:

ExchangeRate = MIN(ExchangeRateTable[ExchangeRate])

• Now create a new measure to make the calculation:

Valueconverted = SUMX(Table, Table[Amount] * [ExchangeRate])

Be aware that you need to have the columns from your many-to-1 relationship from the oneside on the visualization.

You SUMX table need to be adjusted to your model.

this is just a generic solution needs to be adjusted to your model and needs.